Want to get sysdate down to millisecond or microsecond if possible

Posted on 2011-05-11
Last Modified: 2012-06-27
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?

column1      varchar2(2500)      y            
column2      varchar2(250)      y            
column3      varchar2(205)      y            
column4      varchar2(250)      y            
column5      timestamp(6)                     sysdate      
Question by:bill_home
    LVL 76

    Accepted Solution

    default to systimestamp.  sysdate doesn't have fractional seconds.
    LVL 4

    Expert Comment

    Try this :::

    create table abcd ( col1 datetime)

    insert into abcd
    select GETDATE()

    select * from abcd

    Result Set:
    2011-05-11 17:59:51.927
    LVL 18

    Expert Comment

    @ qasim_md

    The question is in Oracle Zone. Your solution will work only on SQLServer.

    Author Closing Comment

    thanks that did it!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now