Date dd-mm-yyyy

John2112 · March 15th, 2007, 06:30 AM

Hello,

I have a table with one of the fields a date field with value (getdate()). When a new record is added this field is not only filled with the current date but also the current time.
I am searching for a way to have only the date (when the record was added) in a 10 position field like this: dd-mm-yyyy.
Who can help?
Many thanks in advance.

happygv · March 15th, 2007, 06:51 AM

Here you go...

Code:

select convert(varchar(10), getdate(), 105)

Cheers.

_________________________
- Vijay G
Strive for Perfection

John2112 · March 16th, 2007, 05:15 AM

Thanks Happygv!