[MonetDB-users] how we convert the value of timestamp in minutes
how we convert the value of timestamp in minutes
On Fri, Sep 28, 2007 at 02:56:46AM -0700, pawan123 wrote:
how we convert the value of timestamp in minutes
If you mean to extract the minutes field from the timestamp you can use extract (minute from timestamp_expr); Example
select extract (minute from NOW);
With a combination you could calculate the total number of minutes in the time part of the timestamp.
Niels
View this message in context: [1]how we convert the value of timestamp in minutes Sent from the [2]monetdb-users mailing list archive at Nabble.com.
References
This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Niels Nes
-
pawan123