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?
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
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
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
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
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
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
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.