Re: String and date format

2nd Question.
You can always make your select statement specific for that column e.g.
select to_char(mycol_with_date,'DD-MM-YYYY') from ...

Jim
"Olivier Gaumond" <olgeg_at_ift.ulaval.ca> wrote in message news:HYXM7.18872$Mm.2119757_at_wagner.videotron.net...
> How can I specify that the type of a column is 4 characters where the two
> first are capital letters and the two last are digits?
>
> I guess it could be something like this:
> CREATE TABLE MyTable(
> MyColumn CHAR(4) CHECK (MyColumn LIKE ([A-Z][0-9]))
> );
>
> Second question, can I specify a specific date format (i.e. DD-MM-YYYY)
 for
> a specific column or it is only for the entire session or when I query
 date
> from the table?
>
> Oliiver
>
>
>
>
Received on Wed Nov 28 2001 - 04:00:05 CET