posted 12 years ago
Hi,
I have a SQL query: SELECT * FROM mytable WHERE mydate = :mydate
mydate is a TIMESTAMP, but i need to cast it to DATE using Oracle function cast(): SELECT * FROM mytable WHERE mydate = cast(:mydate as DATE)
Unfortunatelly i'm using PreparedStatements, so i set the parameter via method setTimestamp()
Is it possible to do the cast anyway?
Thanks