#12658: Vertica 7.0+ : Disable Precision for Datetime datatype | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 829

IDE for Relational Databases

Back

Tariq Rahiman

tariqrahiman reported 2014-11-05T00:01:26Z · last modified 2014-11-05T19:16:55Z

Vertica 7.0+ : Disable Precision for Datetime datatype

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	16.0

Version: 16.0.0-dev-24

Build #: 40903

Build Date: 2014-Nov-04 02:15:23 PM

Vertica 7.0+ : Disable Precision for Datetime datatype

Open attached ER Model

Enter a Precision for the Datetime datatype

Go to Preview SQL

You can see that no precision is actually generated

Can you disable the precision for datetime data type ?

3 attachments

Screen Shot 2014-11-04 at 4.00.44 PM.png

2014-11-05T00:01:26Z

19 KB
vertica_datetime.xed

2014-11-05T00:01:26Z

595 B
Screen Shot 2014-11-04 at 4.00.37 PM.png

2014-11-05T00:01:26Z

36 KB

All Comments (2) Change History

Ivan Gron

ivangron 2014-11-05T19:15:24Z

datetime is no longer a listed datatype for vertica as it was an alias for timestamp

Tariq Rahiman

tariqrahiman 2014-11-05T19:16:49Z

See comments for updated datatype support for Vertica

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017