Dates in SQL Server

Results 1 to 2 of 2

Thread: Dates in SQL Server

  1. #1
    Join Date
    Dec 1969

    Default Dates in SQL Server

    I&#039;m having real trouble with this. My scenario is this:<BR><BR>input-mm/dd/yyyy<BR>output-dd/mm/yyyy<BR>SQLstored-dd/mm/yyyy<BR><BR>input is how I have to have the date formatted in a HTML form<BR>output is how the date that is entered is spit out<BR>and SQLstored is how the date/time field looks in the SQL database<BR><BR>I am accessing these web pages from Canada, where are servers are. WHAT ON EARTH IS GOING ON?????<BR><BR>Since the output is dd/mm/yyyy and I have to input it mm/dd/yyyy, how do I "decipher" the date outputted so that it comes out mm/dd/yyyy

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Dates and Times

    The link to the ASPFAQs is at the top right corner of this page.<BR><BR>Look at the explanation of how dates and times are stored and displayed in DBs and in VBS. <BR><BR>My only question: Why do you use the mm/dd/yyyy input form?<BR>Or did you want *everything* to be mm/dd/yyyy?<BR><BR>

Posting Permissions

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