| Subject | How to combine date and time? |
|---|---|
| Author | Harriv |
| Post date | 2010-02-18T12:15:03Z |
Hi,
I've legacy database where timestamp is stored in two separate
fields, date and time. How I can combine the values so that I can use
timestamp as a criteria?
Something like this: "SELECT * FROM MY_TABLE WHERE (A_DATE + A_TIME)
I've legacy database where timestamp is stored in two separate
fields, date and time. How I can combine the values so that I can use
timestamp as a criteria?
Something like this: "SELECT * FROM MY_TABLE WHERE (A_DATE + A_TIME)
> '2010-2-18 12:00' "