From: | Gary Evans <garyevans(dot)au(at)gmail(dot)com> |
---|---|
To: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: TImestamp with milliseconds or ten thousandths of a second |
Date: | 2016-09-01 22:48:31 |
Message-ID: | CA+ubHFGp_k7JrXTaz=h7CuYCw8VpEYORab5OyBRh28ofRG99kQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi Jorge,
PostgreSQL should store timestamps down to the microsecond.
Formatting should be:
MI minute (00-59)
SS second (00-59)
MS millisecond (000-999)
US microsecond (000000-999999)ffff is probably a .Net specifier. What API
are you using to connect to PostgreSQL? NGPSQL?
Can find details in the documentation here:
https://www.postgresql.org/docs/9.5/static/functions-formatting.html
Cheers
Gary
On Fri, Sep 2, 2016 at 8:36 AM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mike | 2016-09-04 14:25:13 | alter role - superuser - permissions |
Previous Message | JORGE MALDONADO | 2016-09-01 22:36:05 | TImestamp with milliseconds or ten thousandths of a second |