PostgreSQL implements a nice number of extract features that can be used as DATEPART. We don't have these functions yet so it could be useful to implement them. (I'll volunteer)
http://www.postgresql.org/docs/7.4/static/functions-datetime.html (section 9.8.1)
This seems like a useful addition to the codebase to me
we should at least implement EPOCH (1752627)
This bug was previously known as tracker item 2872897 at http://sourceforge.net/support/tracker.php?aid=2872897
The original assignee of this bug does not have
an account here. Reassigning to the default assignee
for the component, email@example.com.
Previous assignee was firstname.lastname@example.org.
I'm affraid we won't make the EPOCH implementation for Oct2010
Apr2011-SP2 has been released.
The Aug2011 version has been released.
Jul2012-SP1 has been released.
Created attachment 290 [details]
UNIX_TIMESTAMP SQL function to convert a timestamp into an epoch
I would also like to have this included into a future release of MonetDB. At the moment I'm using a simple SQL function that converts a timestamp into an EPOCH timestamp but it'd be better if it's properly implemented as part of the EXTRACT function.