sql query for current day time

[retesh_gondal]

hi,
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?

Retesh...

[AdamGundry]

Try something like this (untested, assumes dates are stored as DATETIME columns or something similar):

SELECT * FROM `table` WHERE DATE_SUB(CURDATE(), INTERVAL 1 DAY) < `date_column`;

Adam

[PikoTech]

I use the european date format (dd/mm/yyyy) however one of my web servers is setup to use US format (mm/dd/yyyy).

If your script is ASP use the following in your top include file perhaps (or just the top of your page?):

<%
Session.LCID = 2057
%>

This will allow you to make SQL querys with ASP in a european format (which I assume is what you was using?).

Hope this helps

[retesh_gondal]

thanks for replies...

what i forgot to write was that i am making a DTS Package so i need to write date format in query itself.

[AdamGundry]

I'm afraid I don't quite understand. Can you clarify what you want to do, please.

Adam

[retesh_gondal]

well....here is want to achive:

i want to write a sql query in sql server itself...query has a condition of selecting current date.... now if i use SQL function "getdate()" i get a particular format of date which is like "september 15, 2004 12:22:12" now i want to specify date in following format "9/15/2004 03:00:00 PM"

hope i am clear this time.