RE: Four digit date
From: <rono_at_fl.envworld.com>
Date: Tue, 21 Apr 1998 11:59:25 -0600
Message-ID: <6hij9d$1vt$1_at_nnrp1.dejanews.com>
Date: Tue, 21 Apr 1998 11:59:25 -0600
Message-ID: <6hij9d$1vt$1_at_nnrp1.dejanews.com>
If you just select DATE_FIELD from TABLE; you will get Oracle's default
format (DD-MON-YY out of the box). The date is not stored as a text string
internally. It is stored as a date. To see the full value use SELECT
TO_CHAR(DATE_FIELD, 'mm/dd/yyyy') FROM TABLE; or change the
format for your database.
<6hgv4i$j9i_at_bgtnsc02.worldnet.att.net>#1/1,
wrote:
on the form, but when sending
DD-MON-YY. I must have missed some
>
still dd-mon-yy. What do you do
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 21 1998 - 19:59:25 CEST