sql - Cannot convert number to date -


i have problem converting number column date, did following

select to_date('12-30-1899 1:00:00','mm-dd-yyyy hh24:mi:ss') + (createdate/1440)  table_a;

and got query result 

10/17/5826 17:18

the month , date including hours , seconds right year different got 5826. same other rows got different results year. did follow examples on here. still got wrong result. can on thanks.

the samples below createdate column values:

1300844909778 1302831103113 1303210978316 1396963615616

date arithmetic in oracle assumes days. stands dividing large number 1440 , adding that number of days starting date. that's why you're getting results in far future.

so value createdate represent? it's not actual date. choice of 1440 denominator suggests think it's meant "number of minutes" if dates far out of expectation not either.

i thought values represented in unix epoch because numbers start 13. except they're way big. current unix timestamps should ten digits. you've got thirteen digits.

could unix epoch plus milliseconds?

i have created sqlfiddle test theory. treating first ten digits of createdate values seconds , adding number unix date produces sensible dates. check out.

so theory holds water. doesn't query. adding 2 dates doesn't make sense. trying achieve? if your're looking interval need subtract earlier date later one.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more