I am using the Oracle9i database. In one of my applications, I need to display time, including milliseconds. The...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
current format is "Hour:Minutes;Seconds". The required format is "Hours:Minutes:Seconds:Milliseconds". Can you help in this issue?
A date datatype does not contain milliseconds. A timestamp datatype stores fractional seconds. If you are using dates you'll have to convert them to timestamp datatypes.
However, if you are using timestamps, try this:
create table ts_info ( ts1 timestamp ) / insert into ts_info (ts1) values (systimestamp) / commit / select ts1, to_char(ts1, 'YYYY-MM-DD HH24:MI:SS.FF') from ts_info /
Dig Deeper on Oracle and SQL
Related Q&A from Lewis Cunningham
How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this?continue reading
I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to ...continue reading
I need a step-by-step procedure for importing text to an Oracle database using a stored procedure.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.