Comparing the strings in PHP did not give the correct results. I responded
earlier with my solution, but basically I did the compare in my SQL
statement to Oracle and selected sysdate as scheddate if scheddate was less
then sysdate. This required a union to get all records.

Thanks for the advice.
Keith

-----Original Message-----
From: Rowland, Graeme [mailto:rowlag@a...]
Sent: Sunday, October 08, 2000 6:34 PM
To: professional php
Subject: [pro_php] RE: Date Fields


If You know the format of the date in your string ie dd-mon-yyyy, then you
can do in to_char(sysdate, 'dd-mon-yyyy') to turn the sysdate into a string
in Oracle. Oracle has many format masks for dates. Please let me know if you
need more.

Graeme Rowland
(Senior Analyst
Insolvency Trustee Services Australia (ITSA)
 Phone +xx xx  xxxx xxxx


> ----------
> From: 	keithwe@w...
> Reply To: 	professional php
> Sent: 	Saturday, October 7, 2000 12:39 AM
> To: 	professional php
> Subject: 	[pro_php] Date Fields
> 
> I pull a date field from Oracle in stuff it in a var in PHP. I am trying
> to compare that var with the system date. I understand that PHP treats it
> as a string. Obviously, comparing strings yields different results then
> comparing tru date values. Is there a way I can compare the var with the
> system date?
> 
> Thanks in advance
> Keith
> 
> ---
> To place your message here, or to sponsor this list, please e-mail
> mailto:p2pinfo@w...?subject=MediaPack, remembering to provide contact
> details for yourself. We will e-mail you a Media Pack within 24 hours.
> 
> 

---
To place your message here, or to sponsor this list, please e-mail
mailto:p2pinfo@w...?subject=MediaPack, remembering to provide contact
details for yourself. We will e-mail you a Media Pack within 24 hours.