Re: SQL timestamps

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

If it's an ISO date type, you can do something like this and get 
midnight of each day -

SELECT timestamp_format(char(isodate) ,'YYYY-MM-DD') FROM yourtable

If you want to get some time later in the day, add hours to the 
timestamp, as here -

SELECT timestamp_format(char(isodate) ,'YYYY-MM-DD') + 12 hours FROM 
yourtable

You need the timestamp_format function on your system - I forget when it 
was brought in, but I'm on 7.1 and it works.

If it's a numeric field in ISO format, that's a different story.

Regards
Vern

On 9/11/2017 1:10 PM, Jack Tucky wrote:
> I am trying to insert data into another table that has a timestamp field,
> but I only have an ISO date in my source table.
>
> I can default everything to 12pm or anything really.  How can I do that?
> Still googling but no luck yet.
>
> Thanks, Art