Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Date and time field question

Date and time field question

From: Matthew Tan <tankc_at_singnet.com.sg>
Date: 2000/04/13
Message-ID: <8d3uh2$t7h$1@mawar.singnet.com.sg>#1/1

Hello,

I am having problem creating a time and date format,

  1. v_timedate := to_char(sysdate,'DD-MON-YYYY HH24:MI:SS');

I will encounter this error message :

"date format picture ends before converting entire input string"

When I change to

2) v_timedate := to_char(sysdate,'DD-MON-YYYY');

It will work fine BUT it will display :

13-APR-00 What happen to the '20' ?

Thanks for any help ! Received on Thu Apr 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US