sql - create column data mysql evaluating hour column -
i have column datatime type hour in mysql, , want read column , create other days each hour(0-23:59). put image explain better. intent with
for rowshour day = 0 if rowhour[i] < rowhour day = day + 1
thanks all. best regards!
the table, , column of date same want
i believe asking 2 columns.
|--id--|--name--|----dt----|--hr--| | 1 | data |2015-04-22| 00 | | 1 | data |2015-04-22| 12 | | 1 | data |2015-04-22| 20 | | 1 | data |2015-04-22| 21 |
for hour (hr) use integer instead of datetime. dt use datetime, have exact minute. when query use date(),
finally can use ever incrementing integer format of this: yyyymmddhh, example 2015-04-22 @ 12 2015042212
Comments
Post a Comment