Anyone know how to extract the date from a datetime stamp as part of the where clause?
eg.
select *
from tableA
where date between '01/08/2009' and '31/08/2009'
(Date is a timestamp!)
Many thanks,
Fiona
Sql – extract date from datetime stamp
datesqlsql servertimestamp
Related Topic
- Javascript – Detecting an “invalid date” Date instance in JavaScript
- Javascript – How to get the current date in JavaScript
- Mysql – How to select date from datetime column
- Sql – How to UPDATE from a SELECT in SQL Server
- Php – Convert a date format in PHP
- Javascript – How to format a JavaScript date
- Ruby-on-rails – In Ruby on Rails, what’s the difference between DateTime, Timestamp, Time and Date
- Sql – Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
Best Answer
If this is sql server, it's not possible. The timestamp data type's name is misleading, as it does not store any date information of any kind. All it holds is a sequential value that allows you to establish record order (eg, item A was created before item B), and therefore you don't have enough information in that column alone to know on what day the row was created.
Since the link I provided is Sql Server 2000 specific, also check this link for information on SQL Server 2008:
http://msdn.microsoft.com/en-us/library/ms182776.aspx
To build a real timestamp column in Sql Server, use a DateTime (or DateTime2) data type and set it's default value to
getdate()orcurrent_timestamp.