Read any string in DateTime format!

Question

0.00/5 (No votes)

See more:

I am getting some files from third party server .
In this file Date is coming like this -

20300101
209912
201209
20200209

I mean to say some time 6 digit some 8 digit,How we convert it in valid date or date time format.

Posted 20-Sep-12 19:59pm

rummer

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhijit Parab · Accepted Answer · 2012-09-20T20:09:00

Solution 1

Hi,
For 8 digit like '20120921' it is possible to convert.

select convert(date,'20120921',103)

for six digit u need to append '01' to form a valid date and then convert it in same fashion.

Posted 20-Sep-12 20:09pm

Abhijit Parab

Read any string in DateTime format!

1 solution

Solution 1

Add your solution here

Preview 0

Read any string in DateTime format!

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us