tag:blogger.com,1999:blog-5215551487816981140.post8271509142583040593..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Using TRUNC and ROUND on datesMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5215551487816981140.post-90740043148935961392010-04-08T01:08:05.215-07:002010-04-08T01:08:05.215-07:00Thanks for this. I'd never heard of the extrac...Thanks for this. I'd never heard of the extract function before. (And now that I know I'll probably forget it instantly! - but that's not your fault)David Njokuhttps://www.blogger.com/profile/11205924212052603994noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-83687018905452739382010-04-07T10:42:25.179-07:002010-04-07T10:42:25.179-07:00I have to admin I'm surprised this is new to y...I have to admin I'm surprised this is new to you - I've seen some excellent code from you in the past. <br /><br />But as they say if you can learn something new every day... :)Buzz Killingtonnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-82655970058186957282010-04-07T06:19:25.812-07:002010-04-07T06:19:25.812-07:00To extract hour, minute, second from date :
select...To extract hour, minute, second from date :<br />select sysdate,<br /> extract(hour from cast(sysdate as timestamp)) as extract_hour,<br /> extract(minute from cast(sysdate as timestamp)) as extract_minute,<br /> extract(second from cast(sysdate as timestamp)) as extract_second<br />from dual;Anonymousnoreply@blogger.com