|
Home > Archive > MS SQL Server > October 2006 > System date/time function
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
System date/time function
|
|
| Dale Fye 2006-10-25, 6:00 am |
| I have recently upsized from Access to SQL Server 2000.
I have several tables where I want to track the time when a record was
created. I'd like to do this in SQL Server by setting the default value of
the field. In Access, I set the default value to Now(), what is the
appropriate SQL function to return the system date/time?
--
Email address is not valid.
Please reply to newsgroup only.
| |
| Linchi Shea 2006-10-25, 6:00 am |
| Check out getdate()
Linchi
"Dale Fye" wrote:
> I have recently upsized from Access to SQL Server 2000.
>
> I have several tables where I want to track the time when a record was
> created. I'd like to do this in SQL Server by setting the default value of
> the field. In Access, I set the default value to Now(), what is the
> appropriate SQL function to return the system date/time?
>
> --
> Email address is not valid.
> Please reply to newsgroup only.
|
|
|
|
|