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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment