SQL, creating date column with milliseconds

Question

I am trying to create a date column for my database which contains milliseconds.

How do I create a coloumn to store a date in the following format: YYYY-MM-DD HH24:MI:SS:FF3 ??

Thank You .

declare the column datatype as Datetime2 if using Sql server 2008 and above. — Deepshikha, Apr 30 '14 at 08:23
Which Database are you using?Read the documentation of your DBMS to check what datatypes it offers. — Noel, Apr 30 '14 at 08:43
Hi Eat, I am trying to create a table using oracle for toad. Thanks — user3588388, Apr 30 '14 at 08:45
You should still go and read the documentation. Oracle docs are extensive and generally well written. — Steve Pettifer, Apr 30 '14 at 09:22
You should be using TIMESTAMP. Refer the [documentation](http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements001.htm#SQLRF30020) for various datatypes. — Noel, Apr 30 '14 at 09:23

score 2 · Accepted Answer · edited May 23 '17 at 11:50

2

In Oracle, timestamp stores the date and time down to (and beyond) milliseconds.

edited May 23 '17 at 11:50

Community

answered Apr 30 '14 at 09:22

Johanna Larsson

Hi, Thank you. This worked. Is it possible to specify a format for this column? I want to save the values in the following format: YYYY-MM-DD HH:MI:SS:FFF. – user3588388 Apr 30 '14 at 10:04
@user3588388 - dates and timestamps don't have any format - it's the *string representation* that has a format. Use `TO_CHAR` to specify the format when converting from a date/timestamp to a string, e.g. when displaying it on screen or in a report. – Jeffrey Kemp May 01 '14 at 05:00

1 Answers1