Postgres Pro
Downloads
Home   >   mailing lists

TImestamp with milliseconds or ten thousandths of a second - Mailing list pgsql-novice

From JORGE MALDONADO
Subject TImestamp with milliseconds or ten thousandths of a second
Date
Msg-id CAAY=A7-93okpO8depX14fLLrXWCvH8GyGcnHwUoTxN50-ZKYPw@mail.gmail.com
Whole thread Raw
Responses Re: TImestamp with milliseconds or ten thousandths of a second  (Gary Evans <garyevans.au@gmail.com>)
List pgsql-novice
Tree view
Hi,

I am using PostgreSQL to develop an application in .NET where I use a timestamp field. Actually, I am inserting records with the format "yyyy/MM/dd HH:mm:ss". Is it possible to specify milliseconds or ten thounsandths of a second? Is this a PostgreSQL issue or a .NET issue? I guess it is a PostgreSQL issue because the error is generated by the PostgreSQL data provider.

I am trying "yyyy/MM/dd HH:mm:ss.fff" for milliseconds and "yyyy/MM/dd HH:mm:ss.ffff" for ten thousandths of a second but I get an error saying that syntax is not valid.

Respectfully,
Jorge Maldonado

pgsql-novice by date:

Previous
From: amul sul
Date:
Subject: Re: Recommendation about the implementation of a voting process
Next
From: Gary Evans
Date:
Subject: Re: TImestamp with milliseconds or ten thousandths of a second