Date and time

[ADW]

Hi there,
I'm currently producing web tasks using SQL Server 7 which involves developing basic web page templates in order to output results of SQL statements. What I want to do is show the exact date and time that the web task was executed(rather than using the current date and time) which will indicate to the person viewing, just how accurate and up to date the information.

Many thanks in advance.

 

[dianal]

Hello,
May be you could store the date/time information in a dedicated column in your table(s). And then retrieve it when necessary.
D.

 

[jmcpher]

How bout this, add an additional column to the query that looks like "..., GetDate() as ExecTime from..." and then display this as the time that their task ran... "A computer scientist is a person who knows when it is time to hit the computer."

John

johnmc@mvmills.com