

> -----Original Message-----
> From:	Narayanan, Kannan 
> Sent:	Wednesday, November 17, 1999 10:47 AM
> To:	'pgsql-questions@postgresql.org'
> Subject:	How to select the millisecond/microsecond parts of the
> datetime column
> Importance:	High
> 
> Hello,
> 
> Product version: Postgres 6.5.3
> 
> SELECT DATETIME('MILLISECOND', 'NOW'::DATETIME) always returns 0(ZERO) and
> so does 'MICROSECOND'. However a reading of the manuals indicate that the
> database supports much higher precision values. How do I retrieve the
> additional precision values (beyond seconds) when I use the datetime
> field? This is a requirement for a conversion project that I am working
> on. Could someone help please. 
> 
> Thanks
> Kannan

Wed, 17 Nov 1999 10:51:12 -0800
"Narayanan, Kannan" <knarayan@visa.com>
FW: How to select the millisecond/microsecond parts of the dateti
	me column