i need to write a SQL query to retrieve current day records.
Dates stored in my database are in following format:
"m/d/yyyy hh:mm:ss PM"
now when i make a query using getdate() the format i get is
September 19, 2004 4:00 pm
now this format dosen't match my format. what is the solution for this?