Sysdate

I am setting a field to sysdate.
For example.

update table set field1 = sysdate;

 by the way field1 is a varchar...which is fine by me.

When I do this it just makes it 08-Dec-99. Is there a way to make it put the time as well?
For example 08-Dec-99/10:24:12

Thanks for any help.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 10:40:28 CST