bill_home
asked on
Want to get sysdate down to millisecond or microsecond if possible
Hello Experts,
I have the following table. It onlys stores mm/dd/yyy hh:mm:ss:. I would like to see milli or even better micros. How do i do that?
NAME TYPE NULLABLE DEFAULT
column1 varchar2(2500) y
column2 varchar2(250) y
column3 varchar2(205) y
column4 varchar2(250) y
column5 timestamp(6) sysdate
I have the following table. It onlys stores mm/dd/yyy hh:mm:ss:. I would like to see milli or even better micros. How do i do that?
NAME TYPE NULLABLE DEFAULT
column1 varchar2(2500) y
column2 varchar2(250) y
column3 varchar2(205) y
column4 varchar2(250) y
column5 timestamp(6) sysdate
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@ qasim_md
The question is in Oracle Zone. Your solution will work only on SQLServer.
The question is in Oracle Zone. Your solution will work only on SQLServer.
ASKER
thanks that did it!!
create table abcd ( col1 datetime)
insert into abcd
select GETDATE()
select * from abcd
Result Set:
2011-05-11 17:59:51.927