SQL Server Dates

Results 1 to 2 of 2

Thread: SQL Server Dates

  1. #1
    Join Date
    Dec 1969

    Default SQL Server Dates

    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. If I put it in the way it is stored in the database, I get a conversion error.<BR><BR>I am accessing these web pages from Canada, where are servers are. WHAT ON EARTH IS GOING ON????? <BR><BR>EXAMPLE: I want to edit a record. I pull the information into a form that has a textbox titled StartDate. The information is formatted dd/mm/yyyy. FINE, THIS IS HOW IT IS STORED IN THE DATABASE. Now, unless I reformat it to be mm/dd/yyyy, I will get a conversion error.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server Dates

    personally, I&#039;d be casting these into VBScript (or JScript) Date() objects and manipulating them from there, rather than trying to manipulate them as strings.

Posting Permissions

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