PERVASIVE - SQL Double - Date REquests

Question

in my Table column DeliveryDate datatype is "DOUBLE" not Date

How can I select the following example

SELECT .... FROM .... WHERE DeliveryDate>='01.01.2021'

Can I Convert CURRENTDATE() to a DOUBLE Value?

thx

question from:https://stackoverflow.com/questions/65933108/pervasive-sql-double-date-requests

Answer 1

Short answer is that no, you can't just CONVERT a DATE to DOUBLE. If you execute:

select convert(CURDATE(), sql_double)

You will get an error. This is because CURDATE returns a date in the form MMDDYYYY. Because of the slashes, the conversion to Double fails.
You can do something like this:

select convert( concat( DatePart(year,curdate()) , concat(right(concat('00', DatePart(month, curdate())),2) , right(concat('00', DatePart(day, curdate())),2))), sql_double)

But that assumes the DOUBLE is just a YYYYMMDD concatenation of the DATE value.

You need to determine what format your DOUBLE field is and adjust the algorithm to fit your needs.