Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Unanswered: Is the a similar function to NOW()

    Hi,

    I just imported a MS Access table to SQL Server via DTC. The table has a date field in it that I would like to populate automatically. In fact the access table used the Now() funtion to do just that. Evertime an insert statement occured the current date and time would be inserted into the u_createDate field.

    The now function is not working in MS SQL. Is there a similar funciton that will automatically update the u_createDate field when a record in inserted?

    Mike

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    You can use the GETDATE() function.
    Davide Mauri
    http://www.davidemauri.it

  3. #3
    Join Date
    Jul 2003
    Posts
    2
    Originally posted by manowar
    You can use the GETDATE() function.
    Thank you, Mike

Posting Permissions

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