Simple Question PLease URGENT

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 330,092 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,250 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

•

FAQ | Community Rules | Welcome Guide

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 131 | Replies: 1

•

Join Date: May 2008

Posts: 1

Reputation: firas489 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

firas489

Offline

Newbie Poster

Simple Question PLease URGENT

7 Days Ago

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:

Help with Code Tags

(Toggle Plain Text)

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

Last edited by firas489 : 7 Days Ago at 10:02 am.

•

Join Date: Dec 2004

Location: UAE

Posts: 396

Reputation: Sulley's Boo will become famous soon enough

Rep Power: 5

Solved Threads: 9

Sulley's Boo Sulley's Boo is offline

Offline

Posting Whiz

Re: Simple Question PLease URGENT

7 Days Ago

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT to_date(FLD_AS_STRING, 'dd/mm/yyyy') 
FROM Table1
WHERE to_date(FLD_AS_STRING, 'dd/mm/yyyy') > sysdate;
select to_date(FLD_AS_STRING, 'dd/mm/yyyy') 
from Table1
where to_date(FLD_AS_STRING, 'dd/mm/yyyy') > sysdate;