Post reply

Inserting datetime problems

  • 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 😮

  • January 18, 2005 at 5:32 am

    #537804

    Try submitting the data in the format

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

    Phil

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply