Z
Z
zaharoffff2016-04-25 11:49:55
SQL
zaharoffff, 2016-04-25 11:49:55

How to split datetime column into datetime? (ultimately need to run query "same day but later")?

How to split datetime column into datetime ? (ultimately it is necessary to execute the query "on the same day, but later") ?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
I
Igor, 2016-04-25
@Igor_307

If in php

$arr = implode(' ', $date);
$arr[0] //дата
$arr[1] //время

Z
zaharoffff, 2016-04-25
@zaharoffff

SELECT DATE_FORMAT (opers.op_dattime yyyy.mm.dd) is this what the query should look like ? opers - table , op_dattime - date in format yyyy.mm.dd hh:mm:ss) ?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question