AnsweredAssumed Answered

Date Format error

Question asked by hgadige@osius.com on Jun 7, 2017
Latest reply on Jun 9, 2017 by rob.banas

Hello,

I am trying to retrieve data from db based on date given in the where clause.

Given Date : 20160101 000000.000

Query : SELECT ESTIMATE_ID, '0' as MaxId
FROM ESTIMATE
WHERE FLIGHT_END_DATE >=?

(passed date as parameter).

But I'm getting the following error.

Please provide a solution.

 

Thank You,

Harshini

Attachments

Outcomes