Skip Navigational Links
LISTSERV email list manager
LISTSERV - COMMUNITY.EMAILOGY.COM
LISTSERV Menu
Log In
Log In
LISTSERV 17.5 Help - LSTSRV-L Archives
LISTSERV Archives
LISTSERV Archives
Search Archives
Search Archives
Register
Register
Log In
Log In

LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Menu
LISTSERV Archives LISTSERV Archives
LSTSRV-L Home LSTSRV-L Home

Log In Log In
Register Register

Subscribe or Unsubscribe Subscribe or Unsubscribe

Search Archives Search Archives
Options: Use Forum View

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

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

Print Reply
Subject:
Re: Visual Basic formula or function to calculate timestamps?
From:
George Radford <[log in to unmask]>
Reply To:
LISTSERV give-and-take forum <[log in to unmask]>
Date:
Mon, 8 Apr 2002 14:55:48 -0400
Content-Type:
text/plain
Parts/Attachments:
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

COMMUNITY.EMAILOGY.COM CataList Email List Search Powered by LISTSERV