|
-
Jun 25th, 2006, 09:21 PM
#1
Thread Starter
Addicted Member
HELP Re: datetime
Guys i got a problem everytime i save a date in sql it goes like this =
Mon Apr 25 00:00:00 UTC+0800 2005 everytime i show it on the asp page...
The field datatype is declared as datetime. Is there any way i can convert a string to date? I tried using formatedatetime the problem is its function can only be declare as formatdatetime(date(),2) or formatdatetime(now(),2)
what if my textbox is like "6/6/2006"
how can I save it in the field datetime?
Last edited by -=SC@RF@C3=-; Jun 26th, 2006 at 12:25 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|