- Posts: 8
- Thank you received: 0
Convertion of an datetime via SQL (Item-Properties)
- Philipp_Maurice
- Topic Author
- Offline
- New Member
-
Less
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
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.
4 years 5 months ago #19051
by admin
Mike
ETL Architect
Replied by admin on topic Convertion of an datetime via SQL (Item-Properties)
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.