Tutorials: >> ASP.NET | Silverlight | WPF | ASP.NET AJAX | jQuery || Quick Links | Top Posts | Top Performers || .NET Feeds | Links || Subscribe | Blog | Search | Register

Online : 1324 | Welcome, Guest! Login

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

Announcements

August 10 winners shall be declared by 5-Sep.

Winners of July 2010

Winners & Prizes

Sql Server Forum

Write New Post | Search Posts | Un Answered Posts | Forums Home |

how to convert string of date-time to datetime format

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

Alert Moderator

Found interesting? Add this to:

| More

Responses

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

Level: Starter | Status: [Member] | Reply

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..

Abhi_patil, please login to Mark As Answer, if this helps | Alert Moderator

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

Level: Bronze | Status: [Member] | Reply

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

Regards

Abhi_patil, please login to Mark As Answer, if this helps | Alert Moderator

Latest Posts

Bookmark page in asp.net (0) New
Is it Possible to Use Same RPT CrystalReport File in different Report generating aspx page in DOTNET (0) New
How to ceate database architecture from the user module i am provided.What should be the approach!! (2) New
javascript not working (3) New
Please suggest Open source software for Hospital Information system (0) New
How to Colour gridView field (1) New
SQl server Connection of VB in Windows 98 OS (1) New
basic datetime picker date difference or subtract (5) New

More ...

Write New Post

General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 4:00:04 AM