Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I import dates and if so what ASCII format does it accept for DATE or TIMESTAMP columns or do I need to perform my own external conversion of dates & times to a 32 bit integer?

April 26, 2017ASCII columns dates external format import perform TIMESTAMP

0

Posted

Can I import dates and if so what ASCII format does it accept for DATE or TIMESTAMP columns or do I need to perform my own external conversion of dates & times to a 32 bit integer?

1 Answer

0

Posted

You can import dates and INSERTEX accepts any date format known by the server. For example, 1.08.2004 or 1-AUG-2004.