Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL date format required

SQL date format required

From: Eric <staceye_at_picknowl.com.au-NOSPAM>
Date: Wed, 23 May 2001 00:56:24 +0930
Message-ID: <3b0a8532$1@newsserver1.picknowl.com.au> 






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.
Received on Tue May 22 2001 - 10:26:24 CDT












Original text of this message













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