how to convert varchar to date

sureshchandra · Post by **sureshchandra** » Sun Aug 23, 2009 6:45 am

Hi all,
How to convert 2008-08-10 07:53:08:230 into yyyy-mm-dd
(2008-08-10).Please....

Regards
suresh

chulett · Post by **chulett** » Sun Aug 23, 2009 6:49 am

There's not a lot of true 'converting' in Server, it is very forgiving. Here, since your format is correct, you can either substring the date portion or use Field() to get it:

Code: Select all

YourField[1,10] -or- Field(YourField," ",1,1)

sureshchandra · Post by **sureshchandra** » Sun Aug 23, 2009 7:30 am

Hi,
Thanks for your response.For yyyy-mm-dd i'm using as "D YMD[4,2,2]"
Can you help me in converting this format (yyyy/mm/dd hh:mm:ss)
as yyyy/mm/dd.

thanks
suresh

chulett · Post by **chulett** » Sun Aug 23, 2009 9:16 am

Again, there's no "coversion" needed here, just a substring to remove the time portion.

And you would use "D-YMD[4,2,2]" for "yyyy-mm-dd". Note the dash between the "D" and the "M" to match the delimiter needed/used.