Re: date mask

From: gazzag <gareth_at_jamms.org>
Date: 6 Feb 2007 02:58:32 -0800
Message-ID: <1170759512.150426.60280@a75g2000cwd.googlegroups.com>

On 5 Feb, 19:54, "kostrikov" <kostri..._at_gmail.com> wrote:
> Hi all,
>
> Can I define a mask for date column?
> I need to input dates in the yyyy-mm-dd format.
>
> thanks

SQL> select to_char(sysdate, 'YYYY-MM-DD') from dual;

TO_CHAR(SY

---

2007-02-06

HTH -g Received on Tue Feb 06 2007 - 04:58:32 CST