Hi David, It's already mentioned in the docs:
*Note: in order to better understand the behavior of windowing, we simplify the displaying of timestamp values to not show the trailing zeros, e.g. 2020-04-15 08:05 should be displayed as 2020-04-15 08:05:00.000 in Flink SQL Client if the type is TIMESTAMP(3).* Best regards, Martijn On Fri, Aug 30, 2024 at 1:22 PM David Radley <david_rad...@uk.ibm.com> wrote: > Hi , > I am looking at > https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/queries/window-tvf/ > and tried to follow the instructions, but it was not as I expected. > > I created a javascript program to populate a table defined as per the docs > in the Tumble section. Unfortunately timestamps all came out as null when I > issued a select on the Bids table. The reason is that the timestamp string > as not valid. > > For example timestamp ?2020-04-15 08:05? fails because it is invalid, but > string ?2020-04-15 08:05:00.000Z? works. > > This is confusing for new users. I am happy to raise an issue and fix the > docs. Is someone would be willing to assign me the issue and then merge the > change, > Kind regards, David. > > Unless otherwise stated above: > > IBM United Kingdom Limited > Registered in England and Wales with number 741598 > Registered office: PO Box 41, North Harbour, Portsmouth, Hants. PO6 3AU >
