Inserting datetime problems

• Wayne Fisher-200121

  SSC Rookie

  Points: 42

  More actions

  January 18, 2005 at 4:57 am

  #86592

  Hi, im fairly new to SQL, and as such I am having problems with the DATETIME fields and especially inserting data into them. I have a intranet site running ASP pages sending data to the SQL database, the dates are in the '25-01-2005' format and the time in '12:00' format, but they are not entering into the DATETIME fields, what do i need to do to get them to enter??

  help 😮

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  January 18, 2005 at 5:32 am

  #537804

  Try submitting the data in the format

  'yyyy-mm-dd hh:mm:ss'

  Phil

  ---

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 18, 2005 at 5:58 am

  #537807

  See, if this helps:

  http://www.karaszi.com/sqlserver/info_datetime.asp

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]