Member Avatar for firas489

Hello All,

I'm having a little problem in witting an SQL statement.
I'm sure there is a simple solution for it but its just not clicking with me!.

Anywayz,

I'm trying to write a statement that in the FROM clause, there is a formula, and i would like to assign conditions to this formula in the WHERE Clause
Ex:

SELECT DateValue(FLD_AS_STRING) FROM Table1 WHERE ???

I want the statement to convert the FLD_AS_STRING field (which is in string format) to Date format, and in the same time i want to only view fields that it's FLD_AS_STRING is greater than today's date (after it is converted to Date)?

How can i do that in this statement?


Thanks in advance,


Best Regards
Firas S Assaad

  • 2 Contributors
  • 1 Reply
  • 71 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Sulley's Boo
Member Avatar for Sulley's Boo 
select to_date(FLD_AS_STRING, 'dd/mm/yyyy') 
from Table1
where to_date(FLD_AS_STRING, 'dd/mm/yyyy') > sysdate;
commented: :-P I knew that (kidding ;-)) +6
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.