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.
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
<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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl.
