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