How to convert date to string value?

[JenHu]

Hi expert,

I have a data field (birthdate) contains a datetime datatype
(mm/dd/yyyy), how can I convert to mmdd??
say, the birthday is 8/1/1979 and convert to mmdd

DOB = DS.Tables("Acct InfoTble").Rows (3)("BRTHDATE")
strResult.Inser t(12, DOB.PadLeft(37, " "))

---------------------------------------------------------------------------------------------------

Public Function GenerateA(ByRef strEmpID As String)
Dim strResult As New System.Text.Str ingBuilder
Dim GPConnection As SqlConnection
Dim dr As SqlDataReader
Dim GPDataset As New DataSet

GPConnection = New
SqlConnection(" ............... ............... ............... ")
Dim GPDataAdapter As New SqlDataAdapter( "SELECT
LASTNAME,FRSTNA ME,BRTHDATE FROM UPR00102 where EmployID=' " +
strEmpID + "'", GPConnection)

Dim EfundAcct As String
Dim LName as string
Dim FName as string
Dim DOB as string

GPConnection.Op en()
GPDataAdapter.F ill(GPDataset, "AcctInfoTb le")
Dim DS As DataSet = New DataSet
LName = DS.Tables("Acct InfoTble").Rows (1).Item("LASTN AME")
FName = DS.Tables("Acct InfoTble").Rows (2)("LASTNAME")
DOB = DS.Tables("Acct InfoTble").Rows (3)("BRTHDATE")

............... .....
'Position 13 16N First Name
strResult.Inser t(12, FName.PadLeft(1 6, " "))
............... .....
'Position 37 4A Birthdate
strResult.Inser t(12, DOB.PadLeft(37, " "))

GPConnection.Di spose()
Return strResult.ToStr ing
End Function

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Herfried K. Wagner [MVP]]

"JenHu" <je**********@h otmail-dot-com.no-spam.invalid> schrieb:

I have a data field (birthdate) contains a datetime datatype
(mm/dd/yyyy), how can I convert to mmdd??
say, the birthday is 8/1/1979 and convert to mmdd

\\\
Dim s As String = _
Date.ParseExact ( _
"8/1/1979", _
"d\/M\/yyyy", _
Nothing _
).ToString("MMy yyy")
///

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

JenHu

\\\
Dim mystring as string = mydatetimefield .tostring("MMdd ") that is all
///

By the way every "datetime" field in Net is in every culture in the format
MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

I hope this helps

Cor

"JenHu" <je**********@h otmail-dot-com.no-spam.invalid>

Hi expert,

I have a data field (birthdate) contains a datetime datatype
(mm/dd/yyyy), how can I convert to mmdd??
say, the birthday is 8/1/1979 and convert to mmdd

DOB = DS.Tables("Acct InfoTble").Rows (3)("BRTHDATE")
strResult.Inser t(12, DOB.PadLeft(37, " "))

---------------------------------------------------------------------------------------------------

Public Function GenerateA(ByRef strEmpID As String)
Dim strResult As New System.Text.Str ingBuilder
Dim GPConnection As SqlConnection
Dim dr As SqlDataReader
Dim GPDataset As New DataSet

GPConnection = New
SqlConnection(" ............... ............... ............... ")
Dim GPDataAdapter As New SqlDataAdapter( "SELECT
LASTNAME,FRSTNA ME,BRTHDATE FROM UPR00102 where EmployID=' " +
strEmpID + "'", GPConnection)

Dim EfundAcct As String
Dim LName as string
Dim FName as string
Dim DOB as string

GPConnection.Op en()
GPDataAdapter.F ill(GPDataset, "AcctInfoTb le")
Dim DS As DataSet = New DataSet
LName = DS.Tables("Acct InfoTble").Rows (1).Item("LASTN AME")
FName = DS.Tables("Acct InfoTble").Rows (2)("LASTNAME")
DOB = DS.Tables("Acct InfoTble").Rows (3)("BRTHDATE")

............... ....
'Position 13 16N First Name
strResult.Inser t(12, FName.PadLeft(1 6, " "))
............... ....
'Position 37 4A Birthdate
strResult.Inser t(12, DOB.PadLeft(37, " "))

GPConnection.Di spose()
Return strResult.ToStr ing
End Function

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Herfried K. Wagner [MVP]]

"Cor Ligthert" <no************ @planet.nl> schrieb:

By the way every "datetime" field in Net is in every culture in the format
MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

'DateTime' is not stored in string format and doesn't have a format per-se.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

"Herfried K. Wagner [MVP]"

By the way every "datetime" field in Net is in every culture in the
format MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

'DateTime' is not stored in string format and doesn't have a format
per-se.

Did I write that?

What do you want to say with this sentence?

Cor

[Herfried K. Wagner [MVP]]

"Cor Ligthert" <no************ @planet.nl> schrieb:

By the way every "datetime" field in Net is in every culture in the
format MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

'DateTime' is not stored in string format and doesn't have a format
per-se.

Did I write that?

You wrote that "every "datetime" field in Net is in every culture in the
format MM/dd/yyyy/hh/mm/ss", which is either misleading or false.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

>>>> By the way every "datetime" field in Net is in every culture in the

format MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

'DateTime' is not stored in string format and doesn't have a format
per-se.

Did I write that?

You wrote that "every "datetime" field in Net is in every culture in the
format MM/dd/yyyy/hh/mm/ss", which is either misleading or false.

Can you give me than what it is?

Cor

[Herfried K. Wagner [MVP]]

"Cor Ligthert" <no************ @planet.nl> schrieb:

> By the way every "datetime" field in Net is in every culture in the
> format MM/dd/yyyy/hh/mm/ss, therefore it is not needed to tell that.

'DateTime' is not stored in string format and doesn't have a format
per-se.

Did I write that?

You wrote that "every "datetime" field in Net is in every culture in the
format MM/dd/yyyy/hh/mm/ss", which is either misleading or false.

Can you give me than what it is?

It's formatless. In VB6, dates were stored as a 'Double' value. That's not
the case for .NET. In .NET, 'DateTime' values are stored in a 'Int64'.

<URL:http://sharedsourcecli .sscli.net/source/browse/sharedsourcecli/clr/src/bcl/system/datetime.cs?rev =1.1.1.1&conten t-type=text/vnd.viewcvs-markup>
says:

| // This value type represents a date and time. Every DateTime
| // object has a private field (Ticks) of type Int64 that stores the
| // date and time as the number of 100 nanosecond intervals since
| // 12:00 AM January 1, year 1 A.D. in the proleptic Gregorian Calendar.

So, on the one hand, there is the internal representation, which doesn't
have a human-readable format. In this particular case the date and time is
stored as "the number of 100 nanosecond intervals since 12:00 AM January 1,
year 1 A.D. in the proleptic Gregorian Calendar". On the other hand, there
is the string representation of a 'DateTime', which depends on the culture.
There is no generic format string that applies to all cultures.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Cor Ligthert]

Herfried,

So, on the one hand, there is the internal representation, which doesn't
have a human-readable format. In this particular case the date and time
is stored as "the number of 100 nanosecond intervals since 12:00 AM
January 1, year 1 A.D. in the proleptic Gregorian Calendar". On the other
hand, there is the string representation of a 'DateTime', which depends on
the culture. There is no generic format string that applies to all
cultures.

This is an answer on another question (where did I write that it was in
human readable format by instance) or did tell this in connection with a
string format.

You said that I am misleading when I tell that a datetime is in dotNet
always

Months-Days-Years-Hours-minutes-seconds

So tell than what it is

I am not interested in what kind of bit format it is stored in memory at
all, DateTime is a value format in Net and a format in a database, which I
am thinking from that it is always in the above format. When not, tell than
what format it is and not a kind of novel.

Cor

[Herfried K. Wagner [MVP]]

"Cor Ligthert" <no************ @planet.nl> schrieb:

You said that I am misleading when I tell that a datetime is in dotNet
always

Months-Days-Years-Hours-minutes-seconds

So tell than what it is
It's actually a number of 100 nanoseconds.

This value can be /formatted/ in the format you gave using
'DateTime.ToStr ing' + a specific format string or may be formatted this way
in certain cultures, but 'DateTime' in .NET is not always in the format you
gave.
I am not interested in what kind of bit format it is stored in memory at
all, DateTime is a value format in Net and a format in a database, which I
am thinking from that it is always in the above format. When not, tell
than what format it is and not a kind of novel.

I already told you in what format 'DateTime' is stored in .NET.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>