Create Timestamp From Date and Time

Поиск
Список
Период
Сортировка
От Ron St.Pierre
Тема Create Timestamp From Date and Time
Дата
Msg-id v9wD9.5759$ea.195066@news2.calgary.shaw.ca
обсуждение исходный текст
Ответы Re: Create Timestamp From Date and Time
Re: Create Timestamp From Date and Time
Список pgsql-general
Hi, I'm converting an Access db to Postgresql and want to convert a DATE
startDate and a TIME startTime column into asingle TIMESTAMP startTime
field.
The 7.2 documentation lists a function:
         timestamp(date '1998-02-24',time '23:07')
to do just this, however when I try to run it without hard coding the
date and time fields it fails.

Can anyone enlighten me on what I'm doing wrong?

Thanks

BTW, this function is not listed in the 7.3rc2 documentation(?!)

--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre@syscor.com


В списке pgsql-general по дате отправления: