General discussion


SQL Datetime

By gev98haa ·
I would like to select data between a column "activated_datum" and one week before. The data is saved in datatime format (1999-05-12 10:23:05). Is there anyone who knows how to write this SQL question?

Hanna A

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

isn't there anyone ho can answer then question

by h_dekesel In reply to SQL Datetime

I am looking for that to

Collapse -

Defining Last Week

by artful In reply to SQL Datetime

You can use the AddDate() function -- look it up in BOL. Even simpler, though, is to use simple subtraction, as this example shows:

SELECT GetDate(), GetDate() - 7

Your requirement isn't quite clear to me (select data between a column "activated_datum" and one week before). That could mean several things.

It might look mean:

FROM someTables
WHERE activated_datum
BETWEEN GetDate() AND GetDate() - 7

or you might just begin with:

SELECT activated_datum, activated_datum - 7
FROM someTables

and then play around until you have what you need.


Collapse -

one week before means last 7 days?

by vikas.sharma In reply to SQL Datetime

As its the date format is mentioned I guess "activated_datum" is not a date column.

select * from someTable
where to_date(activated_datum,'YYYY-MM-DD HH24:MI:SS') > sysdate - 7

Collapse -

SQL DateTime query

by SQLHound In reply to SQL Datetime

SELECT activated_datum
FROM TableName
where activated_datum between '1999-05-12' and ('1999-05-12' - 13)

If you're doing this on SQL Server, you might want to check Books On Line for usage of DatePart and GetDate functions.

Collapse -

Amended SQL DateTime Query

by SQLHound In reply to SQL DateTime query

Previous reply should be -6, not -13. -13 is 2 weeks ago.

Collapse -

Try this:

by texasconnelly In reply to SQL Datetime

If you are asking for a rows where the column "activated_datum" is in the last 7 days, try this:

select *
where activated_datum between dateadd(dd, -7, getDate()) and getDate()

Related Discussions

Related Forums