I think you could choose between two solutions (at least) :
1 - Insert date and time in place of timestamp
2 - use some functions like substring. Something like :
select substring('09/12/2003 12:51:31.268 PDT' from '../../ ..:..:..')
Bruno
Shankar K wrote:
oops forgot to mention, database v
> You mean you want to round off to even seconds? Try
> date_trunc,
> or cast to "timestamp(0) with time zone".
well, i just need to trunc whatever thats after the
timestamp i.e from 06/10/2003 12:50:19.188 PDT, i need
to remove .188 PDT
i'll see if date_trunc helps me or not. thanks for the
s
Shankar K <[EMAIL PROTECTED]> writes:
> some has centiseconds in them along with TZ. Now i'm
> wondering is there a way to just extract date and
> timestamp alone leaving the centisecods as well the TZ
> part.
You mean you want to round off to even seconds? Try date_trunc,
or cast to "timestamp(
oops forgot to mention, database version is 7.3.2
--- Shankar K <[EMAIL PROTECTED]> wrote:
> Folks,
>
> Our databases stores most of the dates as timestamp
> with timezone format, so the data looks like this...
>
> 09/12/2003 12:51:31.268 PDT
> 09/12/2003 12:50:20 PDT
>
> some has centiseconds
Folks,
Our databases stores most of the dates as timestamp
with timezone format, so the data looks like this...
09/12/2003 12:51:31.268 PDT
09/12/2003 12:50:20 PDT
some has centiseconds in them along with TZ. Now i'm
wondering is there a way to just extract date and
timestamp alone leaving the c
