Saturday, 17 August 2013

SQL select query for particular date

SQL select query for particular date

My table looks like below
tbPatientEpisode
EpisodeIDP int
EpisodeNumber varcher
EpisodeDate datetime
when try with below SQL query
SELECT * FROM tbPatientEpisode
it show me results like below image..

i want data for particular date like 2013-01-22 for this i tried below SQL
query
SELECT * FROM tbPatientEpisode where EpisodeDate like '%2013-01-22%'
but it does't return any row. what wrong with my query or is there any
proper way to get this kind of result..any help will be appreciate.

No comments:

Post a Comment