DATE time stamp

[EPNICO]

Hello Everyone: Is there a way in sql when you have a field that has date time stamp to extract the mmddyyyy and formatted into mm/dd/yyyy and forget about the time area?

Any ideas are welcome.


Thanks.
Rick

 

[BJCooperIT]

To display it in your desired format:

to_char(timestamp,'mm/dd/yyyy')

If you actually want to remove the time from the field:

to_char(trunc(timestamp),'mm/dd/yyyy')

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
^{When posting code, please use TGML to help readability. Thanks!}

 

[EPNICO]

Thanks for the info. But in my MS SQL 2000 query analyzer I don't find anything in ref. to_char? I'm extracting info for a HR database and creating a delimited output file. So this date field has to have this format mm/dd/yyyy.

Thanks.
Rick:

 

[swampBoogie]

Look up the convert function in BOL.

 

[BJCooperIT]

Always helpful to know what tool you are using. Sorry, my answer was for Oracle.

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
^{When posting code, please use TGML to help readability. Thanks!}

 

[EPNICO]

Thanks for the ideas it pointed me in the right direction the syntax is the following that worked for me on MS SQL 2000.

CONVERT(CHAR(10),EEICWDATAADJUSTED,101)

I get the proper date in mm/dd/yyyy.


Thanks guys.