Results 1 to 19 of 19

Thread: HELP Re: datetime

Threaded View

  1. #1

    Thread Starter
    Addicted Member -=SC@RF@C3=-'s Avatar
    Join Date
    Apr 2002
    Location
    Somewhere in the middle
    Posts
    158

    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
  •  



Click Here to Expand Forum to Full Width