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?
