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
Condense Mail Headers

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

Print Reply
Sender:
LISTSERV give-and-take forum <[log in to unmask]>
Subject:
Re: Visual Basic formula or function to calculate timestamps?
From:
Steven Sobol <[log in to unmask]>
Date:
Tue, 9 Apr 2002 08:57:48 -0400
Content-Type:
text/plain; charset="iso-8859-1"
MIME-Version:
1.0
Reply-To:
LISTSERV give-and-take forum <[log in to unmask]>
Parts/Attachments:
text/plain (30 lines)
This seems to me to have the same problem as the previous answer. First,
it's not a separate field, it's part of the options field, and second, it's
an integer (probably a long integer).

Am I not expressing the problem properly?

-----Original Message-----
From: George Radford [mailto:[log in to unmask]]
Sent: Monday, April 08, 2002 2:56 PM
To: [log in to unmask]
Subject: Re: Visual Basic formula or function to calculate timestamps?


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