Re: sysdate/time syntax
From: Pradhan <empradhan_at_dplus.net>
Date: Tue, 3 Aug 1999 21:34:16 -0400
Message-ID: <TKMp3.263$5I1.211_at_newsfeed.slurp.net>
Date: Tue, 3 Aug 1999 21:34:16 -0400
Message-ID: <TKMp3.263$5I1.211_at_newsfeed.slurp.net>
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') FROM DUAL
HTH
PRADHAN
Joet Singh wrote in message ...
>Quick question:
>What is the syntax for obtaining sysdate and time? I need to set a default
>value for field with both date and time. Any ideas?
>
>
Received on Wed Aug 04 1999 - 03:34:16 CEST