Hi all,
How to convert 2008-08-10 07:53:08:230 into yyyy-mm-dd
(2008-08-10).Please....
Regards
suresh
how to convert varchar to date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 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)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 92
- Joined: Mon May 07, 2007 4:26 am