O$: Date parts

Franco Maregotto franco.maregotto at icloud.com
Sun Mar 12 07:32:45 EDT 2017


hi $all

I'm dealing with the Omnis function dpart(kDayofWeek,date):
it returns
Sun=1, Mon=2, .. Fri=6, Sat=0

PostGreSQL instead select DATE_PART('dow',date) returns
Sun=0, Mon=1, .. Fri=5, Sat=6

I tried to change the weekstart property in library prefs but Sunday always returns 1.
Any suggestion?

Thank you in advance
Franco





More information about the omnisdev-en mailing list