Active IQ Unified Manager Discussions

Date time serialization

olson

Greetings,

                     This is pretty much a sql question however it is behaving differently in mysql workbench and WFA. Here is my query.

SELECT round((CURRENT_TIMESTAMP() + 0),0) as datetm;

In sql workbench it returns correctly in WFA it returns in Scientific notation. Is it possible to force large int notation? I could probably break it up and do date and time and concatenate it during string building. Unless someone has another way to setup a date code?

Many thanks for your time.

John

1 REPLY 1

sinhaa

You didn't mention what scientific notation is returned by WFA and where? I've tried this as a User-Input query and I get the result on format : yyyyMMddhhmmss

SQL yog returns the same. DB visualizer returns as: 2.0140819014506E13

So perhaps the client formats the output before displaying it.

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public