I find this syntax more readable than [`date_sub`](http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-sub), but either way works.

    WHERE timestamp &gt;= NOW() - INTERVAL 6 WEEK

If you want to go by &quot;Today&quot; (midnight) instead &quot;now&quot; (current time), you would use this

    WHERE timestamp &gt;= DATE(NOW()) - INTERVAL 6 WEEK

    where column&gt;=date_sub(now(), interval 6 week)

[This link][1] demonstrates how you might acquire a timestamp of yesterday using the format `DATE_ADD(CURDATE(), INTERVAL -1 DAY)`, therefore your query would probably be:

    WHERE timestamp &gt; DATE_ADD(CURDATE(), INTERVAL -42 DAY)


  [1]: http://www.developertutorials.com/tutorials/mysql-tutorials/exploring-mysql-curdate-now-060817-1005/

**You can use between and `now()`:**


    select somevalue 
    from yourtable
    where yourtimestamp between now() - interval 1 day and now()





for TIMESTAMP there is a [`TIMESTAMPADD()`][1] function 
````mysql
SELECT TIMESTAMPADD(WEEK, -6, CURRENT_TIMESTAMP)
````
this will return the timestemp of 6 weeks ago


or in the case like the question
````mysql
SELECT * FROM users
WHERE lastlogin &gt; TIMESTAMPADD(WEEK, -6, CURRENT_TIMESTAMP)
````


  [1]: https://www.w3resource.com/mysql/date-and-time-functions/mysql-timestampadd-function.php

Any luck yet.  Have you tried:

    &gt;= DATE_SUB(NOW(), INTERVAL 6 WEEK) 

I am querying a data source for dates. Depending on the item I am searching for, it may have more than date associated with it.

    get-date ($Output | Select-Object -ExpandProperty &quot;Date&quot;)

An example of the output looks like:

    Monday, April 08, 2013 12:00:00 AM
    Friday, April 08, 2011 12:00:00 AM

I would like to compare these dates and return which one is set further out into the future.


PowerShell: Comparing dates

i have a list of project objects:

    IEnumerable&lt;Project&gt; projects

a **Project** class as a property called **Tags**.  this is a **int[]**

i have a variable called **filteredTags** which is also a **int[]**.  

So lets say my filtered tags variable looks like this:

     int[] filteredTags = new int[]{1, 3};

I want to filter my list (**projects**) to only return projects that have ALL of the tags listed in the filter (in this case at least tag 1 AND tag 3 in the **Tags** property).

I was trying to use **Where**() and **Contains**() but that only seems to work if i am comparing against a single value.  How would i do this to compare a list against another list where i need a match on all the items in the filtered list ??


filtering a list using LINQ

I have a field named `timestamp`. This is the last time a member was logged in.
I am looking to include a where clause in a query for something like

    WHERE timestamp &gt; todays date - 6 weeks

How would I do this?
I am trying to only include users that have logged in in the last 6 weeks.

Thanks

How do I get Timestamp minus 6 weeks in MySQL?

I have a field named <code>timestamp</code>. This is the last time a member was logged in.
I am looking to include a where clause in a query for something like
<pre><code class="hljs language-sql">WHERE timestamp > todays date - 6 weeks
</code></pre>
How would I do this?
I am trying to only include users that have logged in in the last 6 weeks.
Thanks

I&#39;m learning SQL and what bothers me, is that I seem unable to find ALL constraints on a table. I created the table with

    create table t2
    (a integer not null primary key,
    b integer not null, constraint c1 check(b&gt;0),
    constraint fk1 foreign key(a) references t1(a));

and added a constraint with

    alter table t2
    add constraint c2 check (b&lt;20);

I then tried to see ALL (four) constraints with

    show table status
    from tenn #--&gt;the name of my database
    like &#39;t2&#39;;

and then

    show create table t2;

and then

    select *
    from information_schema.key_column_usage
    where table_name=&#39;t2&#39;;

and finally

    select *
    from information_schema.table_constraints
    where table_name=&#39;t2&#39;;

But none of these shows all four constraints. Could anyone tell me how to see all of them?

Thanks a lot!

MySQL: how can I see ALL constraints on a table?

I am looking for the syntax for dumping all data in my mysql database. I don&#39;t want any table information.

mysqldump data only

In MySQL, I have this stored procedure with a [`LOOP`][1]:

    DELIMITER $$  
    CREATE PROCEDURE ABC()
    
       BEGIN
          DECLARE a INT Default 0 ;
          simple_loop: LOOP
             SET a=a+1;
             select a;
             IF a=5 THEN
                LEAVE simple_loop;
             END IF;
       END LOOP simple_loop;
    END $$

It always prints `1`.  What is the correct syntax for a MySQL Loop?


  [1]: https://dev.mysql.com/doc/refman/5.7/en/loop.html

For loop example in MySQL

My page often shows things like &#195;&#171;, &#195;, &#195;&#172;, &#195;&#185;, &#195;  in place of normal characters.

I use utf8 for header page and MySQL encode. How does this happen?

How to convert these strange characters? (&#195;&#171;, &#195;, &#195;&#172;, &#195;&#185;, &#195;)

Does anyone know how to convert JS dateTime to MySQL datetime? Also is there a way to add a specific number of minutes to JS datetime and then pass it to MySQL datetime?

Convert JS date time to MySQL datetime

The `ObjectId` used as the default key in mongodb documents has embedded timestamp (calling objectid.generation_time returns a datetime object). So it is possible to use this generation time instead of keeping a separate creation timestamp? How will you be able to sort by creation time or query for the last N items efficiently using this embedded timestamp?



uses for mongodb ObjectId creation time

I have a table in a Rails app with hundreds of thousands of records, and they only have a `created_at` timestamp. I&#39;m adding the ability to edit these records, so I want to add an `updated_at` timestamp to the table. In my migration to add the column, I want to update all rows to have the new `updated_at` match the old `created_at`, since that&#39;s the default for newly created rows in Rails. I could do a `find(:all)` and iterate through the records, but that would take hours because of the size of the table. What I really want to do is:

&lt;!-- language: lang-sql --&gt;

    UPDATE table_name SET updated_at = created_at;

Is there a nicer way to do that in a Rails migration using ActiveRecord rather than executing raw SQL?

Update one column to value of another in Rails migration

Well I have a strange problem while convert from unix timestamp to human representation using javascript

Here is timestamp

    1301090400

This is my javascript

    var date = new Date(timestamp * 1000);
    var year    = date.getFullYear();
    var month   = date.getMonth();
    var day     = date.getDay();
    var hour    = date.getHours();
    var minute  = date.getMinutes();
    var seconds = date.getSeconds();  

I expected results to be 2011 2, 25 22 00 00. But it is 2011, 2, 6, 0, 0, 0
What I miss ?

Timestamp to human readable format

I have a table with a field of type bigint. This field store a timestamp.
I want to date format the field like this :

&lt;pre&gt;to_char( bigint_field,&#39;DD/MM/YYYY HH24:MI:SS&#39;)&lt;/pre&gt;

I get the following error :

&lt;pre&gt;
ERROR: multiple decimal points
&#201;tat SQL :42601
&lt;/pre&gt;



How to format bigint field into a date in Postgresql?

When measuring elapsed time on a low level, I have the choice of using any of these:

    System.currentTimeMillis();
    System.nanoTime();

Both methods are implemented `native`. Before digging into any C code, does anyone know if there is any substantial overhead calling one or the other? I mean, if I don&#39;t really care about the extra precision, which one would be expected to be less CPU time consuming?

N.B: I&#39;m using the standard Java 1.6 JDK, but the question may be valid for any JRE...

Content Type	Original Author	Original Content on Stackoverflow
Question	sark9012	View Question on Stackoverflow
Solution 1 - Mysql	700 Software	View Answer on Stackoverflow
Solution 2 - Mysql	ajreal	View Answer on Stackoverflow
Solution 3 - Mysql	Neil	View Answer on Stackoverflow
Solution 4 - Mysql	Eric Leschinski	View Answer on Stackoverflow
Solution 5 - Mysql	Isaac Weingarten	View Answer on Stackoverflow
Solution 6 - Mysql	rd42	View Answer on Stackoverflow

How do I get Timestamp minus 6 weeks in MySQL?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Solution 5 - Mysql

Solution 6 - Mysql

filtering a list using LINQ

PowerShell: Comparing dates

Attributions