lulubell-b
asked on
Search datetime field
Hello,
I need to search only the date in this datetime column. Columns are RequestDateTime, Id and NAME FROM REQUEST
My values in the table are
1 Tom 2012-04-05 15:00
2 Bob 2012-04-05 10:00
3 Mark 2012-03-20 11:00
4 Kirk 2012-04-25 09:00
I want to only search by the date values = 2012-04-05.
This will eventionly go into stored procedure as parameter.
Thanks
I need to search only the date in this datetime column. Columns are RequestDateTime, Id and NAME FROM REQUEST
My values in the table are
1 Tom 2012-04-05 15:00
2 Bob 2012-04-05 10:00
3 Mark 2012-03-20 11:00
4 Kirk 2012-04-25 09:00
I want to only search by the date values = 2012-04-05.
This will eventionly go into stored procedure as parameter.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you