Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Unable to read date '1900-01-01' in sql server
Anil Kumar
May 30 2016 2:52 AM
376
Reply
SELECT * FROM WeekMaster WHERE CAST(GETDATE() AS DATE) BETWEEN CAST(DateFrom AS DATE) AND CAST(DateTo AS DATE)
AND CourseId=95
I am using above sql query for cast date and on the basis of this i get details from table but when i insert '1900-01-01' as date in date column query unable to read that raws field ?
please help if possiable or suggest me to resolve this
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Execute SQL Server stored procedures sequentially.
in which cases we use stored procedures and function?