Results 1 to 2 of 2

Thread: MSDE Timestamp update

  1. 03-15-2004, 11:17 AM #1
    kungfukirk
    kungfukirk is offline Registered User
    Join Date
    Mar 2004
    Location
    Norway
    Posts
    1

    Question MSDE Timestamp update

    Hi!
    How would I go about updating the date in a column with time&date like this "2/2/2003 12:13:45 AM". Is there a easy way to change this on a MSDE dB with a query in Access2000. Could I use a substring function or something?

    This is what i've come up with til now:
    UPDATE table
    SET tablename.column = '2/29/2003 ' + [somefunc(column,something)]
    WHERE tablename.column = '3/1/2003 ' + [somefunc(column,something)]

    If you have any good Answeers please post them. Thank's

    Regard's Christian Kirk
    Reply With Quote Reply With Quote
  2. 03-15-2004, 11:59 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If your column data type is datetime then sql server will store both date and time portion, you don't have to make a string for it, unless you are storing date time as varchar.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules