LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
George Radford <[log in to unmask]>
Mon, 8 Apr 2002 14:55:48 -0400
text/plain (17 lines)
Hi Steven,

On 12:14 PM 4/5/2002 or thereabouts, you wrote:
 >When inserting a record into the database (i.e., subscribing a new list
 >member), I'd like to include a timestamp so that the list owner knows when
 >the list member subscribed.

If your ASP page is doing a SQL insert or calling a SQL stored procedure,
you could use the SQL getdate() function which returns the database
server's current date and time, in datetime format.  Another (even easier)
way to do this is to set the table column's default to getdate() and then
you don't have to insert anything at all -- SQL will fill it in for you
automatically if you don't supply a value in the insert statement.

Regards,
George

ATOM RSS1 RSS2