Intro
Anyone who has ever attended a talk of mine on SQL compatibility has heard my claim that "to support Oracle applications in DB2 we had to add a completely new date-arithmetic library of functions since no two functions operating on date appeared to be the same in DB2."
Well, it appears PostgreSQL has its own set of functions yet again.
So, sooner or later a request for the DATE_PART() function in DB2 was bound to pop up.
Not having PostgreSQL available to test for an exact match, here is what I came up with:
...
[More]
Tags:
extract
doy
epoch
date_part
millenium
decade
century
postgresql
dow
Interesting SQL solutions for DB2 LUW as well as hints on how to move Oracle applications to DB2
X
