Re: Sysdate

From: Alan Shein <alanshein_at_erols.com>
Date: Wed, 8 Dec 1999 12:15:28 -0500
Message-ID: <82m3n8$pns$1@autumn.news.rcn.net>

Like this:

SQL> create table test (f1 varchar2(50));

Table created.

SQL> insert into test select to_char(sysdate, 'mm/dd/yyyy hh:mi:ss') from dual;

1 row created.

SQL> select * from test;

F1

---

12/08/1999 12:06:12

<kray_at_gabrielcom.net> wrote in message news:82m1lr$d01$1_at_nnrp1.deja.com...
> 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 - 11:15:28 CST