Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re^3: DBIx::Simple and Oracle dates

by igelkott (Priest)
on Jun 15, 2010 at 19:42 UTC ( #844925=note: print w/replies, xml ) Need Help??

in reply to Re^2: DBIx::Simple and Oracle dates
in thread DBIx::Simple and Oracle dates

Why isn't "like" appropriate?

As has been said, a useful LIKE statement needs wildcards (otherwise it's just testing equality). Not to stray too far OT, but you'd also need to cast your date to a string (using to_char). Basically, my advice (for what it's worth) is to stick with comparisons like <= for dates.

The part about the nls setting is more important. You should insure that your DBIx connection spits out dates in the same format as your other Oracle clients. Who knows, you could be trying to compare these to ISO 8601 format.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://844925]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2021-04-17 07:30 GMT
Find Nodes?
    Voting Booth?

    No recent polls found