From: | Ange Michel POZZO <poange(at)technologist(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | a question about dates and timestamp |
Date: | 2000-08-03 08:24:38 |
Message-ID: | 00080310393100.00710@ange.alpinfo.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
hi all
i have a table like this
id_message int4 not null default nextval ( ...
id_abonne int4
texte_message varchar() not null
date_message numeric not null
the default size of numeric is 30.6
another table :
id_message int4
id_abonne int4
text_message text
date_message int4
in both case date_message is used to store a unix timestamp ( number of seconds
since 1st of 1970)
for example : 965340000 = 2000-08-03 00:00:00+02
my question is how can i convert the numeric or the int4 value to a date value?
which function should i use to make something like this work ?
select convert_to_date( date_message) from my_table;
2000-08-03 00:00:00+02
2000-08-01 13:56:00+02
etc etc
thanks in advance
Pozzo Ange
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2000-08-03 08:58:38 | Re: a question about dates and timestamp |
Previous Message | Carolyn Lu Wong | 2000-08-03 05:13:32 | What is happening? |