You can translate the question and the replies:

timestamp view parameters

I have created a "view parameter" named "starttime" of type timestamp. When I go to the execution panel I try to enter the starttime. I can't figure out the format I would think it accept me putting in 2023-08-07 00:00:00 -- however it says it is an invalid value and the whole string turns red I tried 2023-08-07 00-00_00 -- also invalid value and the whole string turns red I tried 2023-08-07T00-00-00 -- here '2023-08-0' is green 'T00' is red and -00-00 is green What should i type in that it will accept as a timestamp?
user
07-08-2023 13:39:38 -0400
code

1 Answer

Hi, I’d check the section[ Data Types for Dates, Timestamps and Intervals](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_data_vql/data_types/data_types_for_dates_timestamps_and_intervals) of the Virtual DataPort VQL Guide. You can see there, that you can use for example: `TIMESTAMP '2018-01-15 21:45:01' ` Hope this helps!
Denodo Team
08-08-2023 07:54:28 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here