[RESOLVED] [2005] DateTime

[vijy]

I am getting a datetime like this....
What format is this???

D:20080929130007+05'30'

When am trying to parse like below,error am getting

    Dim dTemp As DateTime= DateTime.Parse(hTemp("CreationDate").ToString())

The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.

[dbasnett]

where did it come from?

[vijy]

From itextsharp..its a third party .net component for manipulating pdf.

am trying to get the cretion time of the pdf..

[dbasnett]

this D:20080929130007+05, looks like

2008 09 29 13:00:07 +05

sep 29 2008

[vijy]

this D:20080929130007+05, looks like

2008 09 29 13:00:07 +05

sep 29 2008

yes yes.. how you converted this..
i need the code..

[vijy]

this D:20080929130007+05, looks like

wthether this an standard time format???

[dbasnett]

not any standard i know of

        Dim tst As String = "D:20080929130007+05"
        Dim newDT As DateTime
        newDT = DateTime.Parse(tst.Substring(6, 2).PadRight(3, " "c) & _
                               tst.Substring(8, 2).PadRight(3, " "c) & _
                               tst.Substring(2, 4).PadRight(5, " "c) & _
                               tst.Substring(10, 2).PadRight(3, ":"c) & _
                               tst.Substring(12, 2).PadRight(3, ":"c) & _
                               tst.Substring(14, 2))

[vijy]

Well.. i too thought of this string manipulation only.,.
thanks a lot for finding the D:20080929130007+05 format...

[jmcilhinney]

The +05 is the offset from GMT, but I don't know what the '30' is for.

Dim s As String = "D:20080929130007+05"
Dim d As Date = Date.ParseExact(s, "D:yyyyMMddHHmmsszz", Nothing)
 
MessageBox.Show(d.ToString(), "Local")
MessageBox.Show(d.ToUniversalTime.ToString(), "UTC")

Unless you're in the GMT+5 time zone then neither of the displayed values will be 1:00:07 PM on September 29, 2008. The second displayed value will be 5 hours before, i.e. 8:00:07 AM, which accounts for the +05 time zone offset. the first displayed value will depend on where you are. I'm in Sydney, Australia and we have daylight saving at the moment. That means our time zone is GMT+10 so I see 6:00:07 PM.