Re: PO7 Time is wrong

From: Murray Kaiser <ae873_at_ccn.cs.dal.ca>
Date: 1995/08/23
Message-ID: <DDsBCy.EL4_at_cs.dal.ca>#1/1


Erwin Grunwald (erwin_at_meaddata.com) wrote:
: I just got the 90-day PO7 (7.1.4) CD. I notice that when I
: query the database using:
 

: select to_char(sysdate,'MM/DD/YY HH:MM:SS') from dual;

                                      ==
 You are using the wrong mask. Should be MI for minute. You are getting the month mask again. I did this one time and it took me hours to figure it out.
--
Murray Kaiser                  | Usual gutless disclaimer.. 
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer
Received on Wed Aug 23 1995 - 00:00:00 CEST

Original text of this message