sql server odbc: NEWBE -- sql server odbc

NEWBE

tony
3/15/2006 9:17:29 AM

sql server odbc:

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

Re: NEWBE

Sue Hoegemeier
3/15/2006 8:20:15 PM

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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.