Jesper Andersson wrote:
[...]
created =VARCHAR(14)
[...]
select CREATED from SUBSCRIBER where date_sub(now(), interval 1 hour) <=
created;
What do I wrong??
The 'created' column is a normal string, the date_sub() function returns
a "time string", i.e. a string on the special format "-MM-DD
H
On Wed, 2005-02-16 at 03:45, Jesper Andersson wrote:
> Hello again,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what new rows have come the last hour.
>
> the db-table (table name is SUBSCRIBER) have the following columns as follows:
>
> ID em
Hello again,
I relly new with databases and writing sql-questions.
But in my db want I to check what new rows have come the last hour.
the db-table (table name is SUBSCRIBER) have the following columns as follows:
ID email created updated
001 [EMAIL PROTECTED] 20
Jesper Andersson wrote:
Hello,
I relly new with databases and writing sql-questions.
But in my db want I to check what have new rows have come the last hour.
the db have I as follow:
ID email created updated
001 [EMAIL PROTECTED] 20050215131034 20050215133401
06
"Jesper Andersson" <[EMAIL PROTECTED]> wrote on 15/02/2005 13:15:43:
> Hello,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what have new rows have come the last hour.
>
> the db have I as follow:
>
> ID email created upd
Hello,
I relly new with databases and writing sql-questions.
But in my db want I to check what have new rows have come the last hour.
the db have I as follow:
ID email created updated
001 [EMAIL PROTECTED] 20050215131034 20050215133401
063 [EMAIL PROTECTE
