MS SQL Server ODBC

Author

NEWBE

tony

2006-03-15, 11:23 am

I have web forms on my site that store data in an sql dbase.

I have a DATE column that i would like to store each date, that each request
was submitted. The only function that i found to automatically populate that
field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
field?

thanks
sorry if im in the wrong room.

Sue Hoegemeier

2006-03-16, 7:24 am

If you want the current date, time you can use GetDate() in
your SQL statement. Or you can use it as a default value.
Depends on what you mean by populate and if it's just for
the creation of a new record, etc.

-Sue

On Wed, 15 Mar 2006 09:17:29 -0800, tony
<tony@discussions.microsoft.com> wrote:

>I have web forms on my site that store data in an sql dbase.
>
>I have a DATE column that i would like to store each date, that each request
>was submitted. The only function that i found to automatically populate that
>field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
>field?
>
>thanks
>sorry if im in the wrong room.

Sponsored Links