Hi @mmattar ,
Is your SQL column a date formatted as text, or an actual datetime?
When rendering dates, it helps to understand the source type vs the display type. It sometimes gets tricky using Text() to render datetimes as it has a source type of DATETIME but will result in a TEXT type output.
In your formula, you're converting Parent.Default to DateTimeValue - the DateTimeValue function expects a text input.
Text(DateTimeValue(Parent.Default),DateTimeFormat.LongTime24)
So, is parent.default actually a string?
The reason it's important is that a source type of DATETIME can be rendered in many ways, but the data will always be the full datetime down to the millisecond. You might only display the year, month, day or hours and minutes, but you can change your mind and display it down to the millisecond if you like because all the data is there.
When rendering off a TEXT type (a date formatted as text), then the only information available is what has already been rendered in text. If the text only shows year/month/day then the rest will default to 00:00:00
In your case, I would expect the SQL data to be an actual DATETIME value, in which case you should be able to just do this;
Text(Parent.Default,"yyy-mm-dd hh:mm:ss")
If it's actually a text type, and it has the seconds as you indicated in your original post, then this should work;
Text(DateTimeValue(Parent.Default),"yyy-mm-dd hh:mm:ss")
Included an example screenshot below - see the last one is a text conversion from the date you originally posted;
Hope this helps,
RT
