Toad World® Forums

Expression Where doesn't return value I need

Hello,

When I use a syntax statement to return a result for DOB in a table, I keep getting an error message that the date is not accepted. The statement is:

Select * from PERSON where DOB > ‘1/1/1960’; What am I doing wrong?

Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘d/m/yyyy’);

Thank you Damir. I ran the script and now I get a message indicating that the Date format is not recognized. Any suggestions?

From: Damir Vadas [mailto:bounce-damirvadas_250@toadworld.com]

Sent: Wednesday, February 04, 2015 1:12 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Damir Vadas

Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘d/m/yyyy’);

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

Do try
Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘dd/mm/yyyy’);

Sent from my Black & Decker Multi-Function Toaster Oven

From: Lucy.Belluscio [mailto:bounce-LucyBelluscio@toadworld.com]

Sent: Wednesday, February 04, 2015 12:38 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Lucy.Belluscio

Thank you Damir. I ran the script and now I get a message indicating that the Date format is not recognized. Any suggestions?

From: Damir Vadas [mailto:bounce-damirvadas_250@toadworld.com]

Sent: Wednesday, February 04, 2015 1:12 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Damir Vadas

Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘d/m/yyyy’);

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender
and delete the material from any computer.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

It worked!!! Daniel, you are a genius!
J Thank so much!

From: Daniel Madvig [mailto:bounce-dbmadvig@toadworld.com]

Sent: Wednesday, February 04, 2015 2:46 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Daniel Madvig

Do try
Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘dd/mm/yyyy’);

Sent from my Black & Decker Multi-Function Toaster Oven

From: Lucy.Belluscio [mailto:bounce-LucyBelluscio@toadworld.com]

Sent: Wednesday, February 04, 2015 12:38 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Lucy.Belluscio

Thank you Damir. I ran the script and now I get a message indicating that the Date format is not recognized. Any suggestions?

From: Damir Vadas [mailto:bounce-damirvadas_250@toadworld.com]

Sent: Wednesday, February 04, 2015 1:12 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Expression Where doesn’t return value I need

RE: Expression Where doesn’t return value I need

Reply by Damir Vadas

Select * from PERSON where DOB > to_date (‘1/1/1960’, ‘d/m/yyyy’);

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material
from any computer.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.