Re: SQL date format required

Oracle dates, such as :
 create table foo (foo_date date)
can be used.
To format the date you want, you can :
 select to_char(foo_date,'DD MM YY HH24') as mydate from foo

HTH, Ted

On Wed, 23 May 2001 00:56:24 +0930, "Eric" <staceye_at_picknowl.com.au-NOSPAM> wrote:

>hi,
>Could anyone lease help me how to generate the proper SQL to format a
>attribute with in the following format:
>dd mm yy hh
>eg create table with attribute/field named date_time has all days, months,
>year, hours and minutes in its format type?
>Do I need separate names for the column names(eg date and time)? Or is there
>a way to do this in one simple statement?
>thanking you in advance
>Eric.
>
>

EMail: knijff_at_bigfoot.com Received on Tue May 22 2001 - 12:38:36 CDT