sql select question

Article View: bit.listserv.sqlinfo

Article #317

Back to bit.listserv.sqlinfo Previous Next

#317

From: 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

Technical Details

Message-ID: <05rf8.38754$6j2.1997199@typhoon.austin.rr.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!newsfeed1.cidera.com!Cidera!cyclone.tampabay.rr.com!cyclone.austin.rr.com!typhoon.austin.rr.com.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,7953a8380f45fcd6,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2002-02-28 06:27:16 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!newsfeed1.cidera.com!Cidera!cyclone.tampabay.rr.com!cyclone.austin.rr.com!typhoon.austin.rr.com.POSTED!53ab2750!not-for-mail
From: "Marian" <mshelton@austin.rr.com>
Newsgroups: bit.listserv.sqlinfo
Subject: sql select question
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <05rf8.38754$6j2.1997199@typhoon.austin.rr.com>
Date: Thu, 28 Feb 2002 14:25:00 GMT
NNTP-Posting-Host: 66.68.132.188
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.austin.rr.com 1014906300 66.68.132.188 (Thu, 28 Feb 2002 08:25:00 CST)
NNTP-Posting-Date: Thu, 28 Feb 2002 08:25:00 CST
Organization: Road Runner - Texas