Hi All.
Well my question is that how can we convert date from mm/dd/yyyy to dd/mm/yyyy or Long Date (ex. Sunday, August 6, 2006).
I searched over the net and I found that we have to use Convert function in our Queries such as:
select Convert (nvarchar, Date, 101) As Date From Table
But my question is in my SQL Server Database I put the type of Date as datetime, what about my dataset? Should it be String or DateTime
P.S. I used String and DateTime in dataset and with String it works correctly.
Can someone guide me please!
Well my question is that how can we convert date from mm/dd/yyyy to dd/mm/yyyy or Long Date (ex. Sunday, August 6, 2006).
I searched over the net and I found that we have to use Convert function in our Queries such as:
select Convert (nvarchar, Date, 101) As Date From Table
But my question is in my SQL Server Database I put the type of Date as datetime, what about my dataset? Should it be String or DateTime
P.S. I used String and DateTime in dataset and with String it works correctly.
Can someone guide me please!
