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
