Top Posts | Top Performers | Tutorials: ASP.NET | Silverlight | ASP.NET AJAX | jQuery Write for us (and win!): Article | Int. Question | Career Question | Job Profile | Code | Question | Joke | Link || Subscribe | Blog | Search | Register

Online : 58 | Welcome, Guest! Login

Home > Forums > Sql Server > how to convert string of date-time to datetime format

Winners & Prizes !

Winners & Prizes

Congratulations !!! to all the winners of November 2009.
Certificates have been sent to all the winners.

Sql Server Forum

Ask a Question | Search Questions | Un Answered Questions | Forums Home |

how to convert string of date-time to datetime format

Reply

i have table report contains colume report_date having datatype nvarchar..

but now i want to get report before specific date..so how i can get that report correctly..

ex. i want to get report <'7/8/2009 10:10:50 AM'
how i can write query for that...

thanks..

Reply

Interesting?

Responses

Bravi
Posted on: 7/13/2009 1:26:18 AM

I hope this code will useful for you try this

Convert(datetime,report_date)<Convert(datetime,'7/8/2009 10:10:50 AM' )

After writing query in where conditon write like this so you can get records..

PandianS
Posted on: 7/13/2009 1:51:28 AM

select Col1,Col2 from report where CAST(Report_Date AS DATETIME) < '7/8/2009 10:10:50 AM'

Regards

Forums Categories

Ask a Question

All rights reserved to DotNetFunda.Com. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
(Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher)