dates and time

Results 1 to 4 of 4

Thread: dates and time

  1. #1
    8575 Guest

    Default dates and time

    I use FormatDATETIME(date,2) and time()<BR>I get 1/3/00 instead of 1/3/2000 ?<BR>and with time I get the correct time, but when I try and insert into database I get 1/3/1900 11:30:am all I want is 11:30am<BR>?<BR>help<BR>

  2. #2
    Krishna Guest

    Default RE: dates and time

    Check out the date settings by double clicking the Regional settings icon which is in the control panel.It should be in the four digit format i.e dd/mm/yyyy.Try this out and reply if u could get it right.

  3. #3
    8575 Guest

    Default RE: dates and time

    i dont have access to the server or sql server, should I write the admin?

  4. #4
    Join Date
    Dec 1969

    Default RE: dates and time

    The date/time displayed by IIS is formatted according to the regional settings for the currently logged-on user or the system default (or is it the Administrator?) if no one&#039s logged on. Try either resetting the system default date/time format or create your own date/time formatting function (which is what I&#039ve ended up doing on all my apps).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts