sql query for current day time
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?
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`;
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
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.
I'm afraid I don't quite understand. Can you clarify what you want to do, please.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)