You've to format the value returned by sql server on the front end, alternatively you could set the datatype of that column to varchar, however, it is not at all the preferred way of doing away with this problem but may fastly come to your rescue [:$]
shashankgwl
All-Star
18926 Points
3662 Posts
Re: How to select Date and Time simultaneously
Oct 21, 2008 03:29 PM|LINK
You've to format the value returned by sql server on the front end, alternatively you could set the datatype of that column to varchar, however, it is not at all the preferred way of doing away with this problem but may fastly come to your rescue [:$]
All is well if it runs well.
blog