Will this work if the prm.datefrom table format is not just a date? It is a date and time value in the table.
Main Topics
Browse All TopicsI have the following partial sql statement that I'm trying to execute from vb.net code:
Dim currdate as string = date.now.tostring('MM/dd/y
select prm.datefrom
from prmmain prm
where to_char(prm.datefrom,'MM/D
prm.datefrom is a datetime column.
This doesn't work because now I'm comparing strings instead of dates. Is there a way for me to convert these back to dates or somehow keep them as dates to begin with?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Well, this doesn't seem to work. I get a oracle error (not a valid month) when I use this query:
Select prm.pkey as prmpkey, prm.TacticParentPKey, jb.PKey as jbpkey, jb.tacticpkey, prm.phase, prm.datefrom, jbmeta.standardjobs From PRMMAIN prm LEFT JOIN JOBDEFINITIONLIST jb on jb.TacticPkey = prm.PKey Left JOIN jobdefinitionlistmeta jbmeta on jbmeta.pkey = jb.jobdeflistmetapkey WHERE ((prm.tacticparentpkey is not null) and (prm.tacticparentpkey <> ' ')) AND jb.tacticpkey is not null AND prm.datefrom >= to_date('02/16/2007')
You forgot the format string (see Razo's solution). The query should look like this:
Select prm.pkey as prmpkey, prm.TacticParentPKey, jb.PKey as jbpkey, jb.tacticpkey, prm.phase, prm.datefrom, jbmeta.standardjobs From PRMMAIN prm LEFT JOIN JOBDEFINITIONLIST jb on jb.TacticPkey = prm.PKey Left JOIN jobdefinitionlistmeta jbmeta on jbmeta.pkey = jb.jobdeflistmetapkey WHERE ((prm.tacticparentpkey is not null) and (prm.tacticparentpkey <> ' ')) AND jb.tacticpkey is not null AND prm.datefrom >= to_date('02/16/2007', 'mm/dd/yyyy')
Business Accounts
Answer for Membership
by: razoPosted on 2007-02-16 at 06:47:18ID: 18548726
select prm.datefrom
from prmmain prm
where prm.datefrom >=to_date('" + currDate + "',mm/dd/yyyy)"