Showing posts with label simplicity. Show all posts
Showing posts with label simplicity. Show all posts

Monday, March 19, 2012

Formatting Dates

Hi all,

Soryy for the question because of its simplicity but i'm newbie.

I have a date column in the following format:

2002-04-01 15:16:32.187

I want to query and show this column in the format:

dd/mm/yyyy

How can I do it in a simple query?. I don't want to use cursors or user defined functions.

Thanks in advance.

God Blessselect convert(varchar(10),getdate(),103)