Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Select more than just *
0 views
Skip to first unread message
The87Boy
Nov 15, 2009, 3:39:42 PM11/15/09
to
Is it possible to run a query like this:
SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
`Admin`
SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
`Admin`
Or should I let PHP calculate the days since update?
toby
Nov 15, 2009, 4:21:47 PM11/15/09
to
On Nov 15, 3:39 pm, The87Boy <the87...@gmail.com> wrote:
> Is it possible to run a query like this:
> SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> `Admin`
> Is it possible to run a query like this:
> SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> `Admin`
Did you try it?
The87Boy
Nov 16, 2009, 2:51:30 AM11/16/09
to
On 15 Nov., 22:21, toby <t...@telegraphics.com.au> wrote:
> On Nov 15, 3:39 pm, The87Boy <the87...@gmail.com> wrote:
>
> > Is it possible to run a query like this:
> > SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> > `Admin`
>
> Did you try it?
> On Nov 15, 3:39 pm, The87Boy <the87...@gmail.com> wrote:
>
> > Is it possible to run a query like this:
> > SELECT *, DATEDIFF(CURDATE(), `updated`) AS `daysSinceUpdate` FROM
> > `Admin`
>
> Did you try it?
Actually no
Gregor Kofler
Nov 16, 2009, 3:58:03 PM11/16/09
to
0 new messages