Re: Just want day but no time information

From: Jan Schaefer <jan.schaefer_at_kksl.uni-leipzig.de>
Date: Fri, 13 Feb 2004 17:30:46 +0100
Message-ID: <c0iu49$408$1@news.uni-leipzig.de>

D. Alvarado schrieb:

> Ideally, it would be great if there's a column type
> that just has day (but no time) information, but I can't seem to find
> such a column type. Any advice on how I can make this constraint
> work?

Test against to_char(date_colum, 'dd.mm.yyyy')

Just my two eurocents,

Jan Received on Fri Feb 13 2004 - 10:30:46 CST

This message: [ Message body ]
Next message: Dave: "Re: Advise needed: Can I use/learn Oracle quickly?"
Previous message: ken quirici: "oracle spool in Windows environment"
In reply to: D. Alvarado: "Just want day but no time information"
Next in thread: Daniel Morgan: "Re: Just want day but no time information"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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