Help on Date Query in specific format

Posted by Vijayar under C# on 8/18/2011 | Points: 10 | Views : 986 | Status : [Member] | Replies : 1
I have a table with eventdate and event of holidays in a table,now i need to bind list of holiday information in current month with day in dd-mm-yyyy format by side of it
How to do this
example aug 15th independence day
Independence date 15-aug-2011-mon should appear in grid where as
in table
15-08-2011 Independence day
Please help me .It's very urgent



Posted by: Dhirendra on: 8/19/2011 [Member] Starter | Points: 25

use this sql query to convert it to dd-mm-yyyy format
SELECT convert(varchar, eventdate(), 105)

Vijayar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response