Re: data import: 12-hour time w/o AM/PM

Поиск
Список
Период
Сортировка
От Leif Biberg Kristensen
Тема Re: data import: 12-hour time w/o AM/PM
Дата
Msg-id 201102081925.54790.leif@solumslekt.org
обсуждение исходный текст
Ответ на data import: 12-hour time w/o AM/PM  (Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de>)
Список pgsql-sql
On Tuesday 8. February 2011 19.14.00 Tarlika Elisabeth Schmitz wrote:
> From the date and time I want to create a timestamp.
> I know that 
> - the events take place during the day, say between 10:30 and 22:30
> - it's always a set of events at one location spaced about 30min apart
> - the imported data are chained (have a link to previous/next event)
> 
> 
> Have you got any idea how I could tackle this problem

Add 12 hours if time is in the interval 1:00-10:30?

regards,
Leif


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

Предыдущее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: data import: 12-hour time w/o AM/PM
Следующее
От: Andrej
Дата:
Сообщение: Re: data import: 12-hour time w/o AM/PM