Thx I will give that a try. Dan Goldberg
From: [email protected] <[email protected]> On Behalf Of Tony IJntema Sent: Friday, May 21, 2021 10:52 AM To: [email protected] Subject: Re: [RBASE-L] - change date to datetime Dan, Try this: Create a new column like date_time_field DATETIME in the table Then perform the next statement (where datefield is the original date column) UPDATE Testdate SET date_time_field = (DATETIME(datefield,00:00)) Tony Op 21-05-2021 om 19:18 schreef Dan Goldberg: I am trying to change a date column to datetime and it is giving me this error. [cid:[email protected]] How do I change it? Do I have to do a unload/change it/load? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CAE33%40EXCHANGE10<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CAE33%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl<https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CB0F5%40EXCHANGE10.
