kruzulis (![[info]](http://klab.lv/img/userinfo.gif){kind=small} kruzulis) rakstīja, |
1/(24*60*60) ir domāts viena sekunde?
SELECT to_date('20071106', 'yyyymmdd') AS date_from, to_date('20071105235959', 'yyyymmddhh24miss') AS date_to FROM dual
UNION ALL
SELECT to_date('20071106', 'yyyymmdd')- 1 / (24 * 60 * 60) AS date_from, to_date('20071105235959', 'yyyymmddhh24miss') AS date_to FROM dual;
SELECT to_date('20071106', 'yyyymmdd') AS date_from, to_date('20071105235959', 'yyyymmddhh24miss') AS date_to FROM dual
UNION ALL
SELECT to_date('20071106', 'yyyymmdd')- 1 / (24 * 60 * 60) AS date_from, to_date('20071105235959', 'yyyymmddhh24miss') AS date_to FROM dual;
Nopūsties:
