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)
Showing posts with label simplicity. Show all posts
Showing posts with label simplicity. Show all posts
Monday, March 19, 2012
Formatting Dates
Subscribe to:
Posts (Atom)