sql select question

Thread View: bit.listserv.sqlinfo

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Marian Thu, 28 Feb 2002 14:25

#317

Author: Marian
Date: Thu, 28 Feb 2002 14:25

17 lines
1641 bytes

If I sent this to the wrong address, please forgive me.  I lost all my
e-mail and settings and have been trying to get everything set back up.

Anyway,
I'm trying to get a date to print from the following select statement, that
is 14 days prior to the current date and have it print out in date format
Feb 27, 2002.  Can anyone tell what I'm doing wrong??

&run_statement("select subdate('date_format(now('CURRENT_DATE'), '%b %e,
%Y') CURRENT_TIME', interval '-14 0:0' day_minute);");
     while(($begin_date) = $sth->fetchrow){

            print "$begin_date";
}

Thanks,
Marian

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads