Selecting timestamp from Database
От
Richard Harley
Тема
Selecting timestamp from Database
Дата
Msg-id
5134386C-0F49-4E46-98D9-E2FBA34E9B2B@scholarpack.com
Список
Дерево обсуждения
Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Re: Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Re: Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Re: Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Re: Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Re: Selecting timestamp from Database Tom Lane <tgl@sss.pgh.pa.us>
Re: Selecting timestamp from Database Richard Harley <richard@scholarpack.com>
Re: Selecting timestamp from Database Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: Selecting timestamp from Database Adrian Klaver <adrian.klaver@gmail.com>
Hello all
Pretty sure this should be simple - how can I select a timestamp from a database?
The timestamp is stored in the db like this:
| 2013/04/08 13:54:41 GMT+1 |
How can I select based on that timestamp?
At the simplest level "select timestamp from attendance where timestamp = '2013/04/08 13:54:41 GMT+1'"
..doesn't obviously work but I've tried all sorts of to_char and to_timestamp combos to no avail..
Any ideas?
Cheers
Rich
В списке pgsql-general по дате отправления
