PDA

View Full Version : Timestamp Field

donaldt
06-17-02, 08:01
Hello !

I need to record date & time when a new record is added ot the field is updated.

I have used the timestamp value which shows as 'binary' when the row is updated but does not show the date.

Can anyone help please ?

Thanks
r937
06-17-02, 16:38
which database?
alligatorsql.com
06-21-02, 13:20
Itīs always the same ... everybody thinks his database system is the one and only :)
donaldt
06-24-02, 04:05
Originally posted by r937
which database?

SQL 7 - sorry !
rnealejr
06-24-02, 10:02
Use getdate or getutcdate.