hello,
i need to use Format Function in select query in C#.NET.
my requirement is i need to display date in formated manner such as "01-Jan-2001"
but data grid in my forms C# shows "1/1/01" i need it on "01-Jan-2001" this format
what can i do.
Loading
Jan MontanoPosted Aug 14, 2007, 4:16 AM
select substring(convert(varchar,getDate(),113),1,11)
113 is the style for dd mmm yyyy time