#12099: Does not show microseconds value for timetz datatype in Vertica 7.0

vaibhavladdha271(*) reported 2014-05-09T09:11:56Z · last modified 2014-11-04T23:20:18Z

Does not show microseconds value for timetz datatype in Vertica 7.0

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Vertica
Version	16.0

Aqua Data Studio 15.0.0-dev-273
Build #: 37771
Built on: 2014-May-08 03:31:58 PM

Operating system: Windows 7 x64

Database: Vertica 7.0.0

Steps to reproduce:
1)Create a table named 'test_datetime'
Create table script:

CREATE TABLE "dbschema"."test_datetime" (

"col1" date,

"col2" time,

"col3" timetz,

"col4" timestamp,

"col5" timestamptz,

"col6" int,

"col7" varchar(80) NOT NULL,

CONSTRAINT "pk" PRIMARY KEY("col7")

)

GO
2)Insert data into table:
Insert script:

INSERT INTO "dbschema"."test_datetime"("col1", "col2", "col3", "col4", "col5", "col6", "col7")

VALUES('2014-5-9', '13:50:39', '13:50:39.54', 'April 1, 45 BC', 'June 1, BC 2000 03:20 PDT', 9, 'Test9')

GO
3)Go to File menu->options
Select Results formatter
Select 'timetz' datatype from Vertica & select 'HH:mm:ss.SSS' from Format field
Click on Ok button
4)Right click on created table & select Script object to window as->select(*) & run query
Timetz value is displayed correctly in query analyzer window
5)Right click on create table & select Edit table data
Here microseconds value for timetz datatype is not displayed