Title
#users-public
d

Derek

09/08/2022, 7:25 PM
Good day! Could someone please help me? I’m trying to find the right timestamp pattern to use for this format.
2020-10-28 21:53:01.244441+00
Nicolas Hourcard

Nicolas Hourcard

09/08/2022, 7:49 PM
hey Derek! How urgent is this ? We still have most of the coredb team in EU timezone (team is growing fast and adding new people in US/Asia timezone as we speak!) so for non critical issues it sometimes will be difficult to get responses right away. let me know
d

Derek

09/08/2022, 7:57 PM
Hey, that’s great to know! It’s not urgent, and thank you for the quick reply 👍
9:21 PM
Found the supported formats in TimestampFormatUtils.java 🤙 In case anyone else needs it, I went with
yyyy-MM-ddTHH:mm:ss.SSSUUUz
(had to include “T” in the export)
Nicolas Hourcard

Nicolas Hourcard

09/08/2022, 9:48 PM
great !
j

javier ramirez

09/09/2022, 8:14 AM
Is this for importing data? If so, you can actually define your own format https://questdb.io/docs/guides/importing-data-rest#example
8:15 AM
You need to create a conf/text_loader.json file adding the date or timestamp format you need, and make sure you uncomment the text_loader.json property at the server.conf directory
8:15 AM
the text_loader.json file needs to be in that same conf directory