I figured out every element of it except TIMEZONE. Does anybody know if Oracle has a format string for timezone ?
select to_char(sysdate, 'dy mon dd hh24:mi:ss') from dual; TO_CHAR(SYSDATE,'DY ------------------- mon oct 01 16:07:54 Thanks, Jie "Kokarski, Anton" wrote: > I believe you will need to figure out the format string for it and it should > work > > Anton > > -----Original Message----- > From: jie zhang [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 3:59 PM > To: [EMAIL PROTECTED] > Subject: date format in Oracle > > Does anybody know if Oracle can take the date format as 'Thu Sep 20 > 15:03:10 PDT 2001') ? > > Thanks in advance, > > Jie
