Convertion of an datetime via SQL (Item-Properties)

More
4 years 5 months ago #19050 by Philipp_Maurice
Dear Support-Team

I just created an item in which i select dates from my sql database.
The selected date is in the following format: yyyy.mm.dd hh:mm:ss.

If i select the converted datetime via the item, the dates in which the time is 00:00:00 are minimized to the format: "yyyy.mm.dd".

Thanks in advance for your help.

Yours sincerly,
Phil

Please Log in or Create an account to join the conversation.

More
4 years 5 months ago #19051 by admin
Not sure that I understand the question. What exactly do you suggest?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.