Re: Sysdate

From: <saustin_deja_at_my-deja.com>
Date: Wed, 08 Dec 1999 18:35:24 GMT
Message-ID: <82m8dc$ili$1@nnrp1.deja.com>

Sorry, I meant to say
field1=to_char(sysdate,'DD-MON-YY/HH24:MI:SS')

In article <82m1lr$d01$1_at_nnrp1.deja.com>, kray_at_gabrielcom.net wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 12:35:24 CST