datetime value
-
i am geting value from datbase with this code CONVERT(varchar(11), TH_DT_HolidayDate) AS Expr1 and output is jan 15 2009 . but i want output like jan 15,2009 .how can i do this .thnx in advance.
-
i am geting value from datbase with this code CONVERT(varchar(11), TH_DT_HolidayDate) AS Expr1 and output is jan 15 2009 . but i want output like jan 15,2009 .how can i do this .thnx in advance.
The way you're doing this, it's a SQL question. Return a date time instead and use the ToString method to return the date formatted as you'd like.
Christian Graus Driven to the arms of OSX by Vista.
-
i am geting value from datbase with this code CONVERT(varchar(11), TH_DT_HolidayDate) AS Expr1 and output is jan 15 2009 . but i want output like jan 15,2009 .how can i do this .thnx in advance.
CONVERT(varchar(11), TH_DT_HolidayDate , 18) may be 18 not sure , u can change this digit from 10 to 19 and then check them
-
CONVERT(varchar(11), TH_DT_HolidayDate , 18) may be 18 not sure , u can change this digit from 10 to 19 and then check them
thnx..