> So what would a update command look like for updating a date field to the
> current time
>
> UPDATE X
> Set MyDate = TIMESTAMP

Set MyDate = CURRENT_TIMESTAMP

Do read the messages correctly :)

>
>
> I want the entire date and time to be stored.
> Will the above be correct.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."