Saturday, February 25, 2012

Date Format

Hi!!!
My procedure get a date using the function getdate() and insert in the datetime field.
I.e. 04/04/03 09:55:18
I would like format my data without time.
Excuse me my simple english.
Thank you.Hello,

you use Oracle I guess ??

For Oracle use TRUNC(datefield) to TRUNCate the time value.

Hope that helps ?

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com

No comments:

Post a Comment