Hi Rainer, in getSQLPhrase there is CURRENT_DATE and CURRENT_DATETIME. Whats the difference, if CURRENT_DATE includes the Time?
Von meinem iPhone gesendet > Am 15.01.2018 um 09:32 schrieb Rainer Döbele <[email protected]>: > > IMO this looks like a bug in the PostgresSQL driver. > DBDatabase.SYSDATE is a constant expression for a timetstamp and > getSystemDateExpr() should simply return a DBColumnExpr object as a wrapper > for this object so that functions can be applied to it. > > Looks like in Prostgres Now() supplies a timestamp whereas CURRENT_DATE only > supplies the date without time. > Hence DBDatabase.SYSDATE should IMO be mapped to Now(). > > Regards > Rainer > >> from: Jan Glaubitz [mailto:[email protected]] >> to: [email protected] >> re: DBDatabase.SYSDATE vs. getSystemDateExpr() >> >> Hi all, >> >> I just noticed that there is a difference between using DBDatebase.SYSDATE >> and the method getSystemDateExpr(). >> >> DBDatabase.SYSDATE results in CURRENT_DATE (eg 2018-01-15), but >> getSystemDateExpr() results in NOW() (eg 2018-01-15 09:22:05.063118+01). >> >> Is this on purpose or a Bug? >> >> - jan >> >> Von meinem iPhone gesendet
