I guess you could try changing the colum to date instead of timestamp to see if it makes any difference.
alter table vaccinations alter column vdate type date
Graham:alter table vaccinations alter column vdate type date
that worked.
Ok, must be some windows local date setting on your server that is causing an issue, or, perhaps you're running a very old version of firebird.
older firebird.
Mine likely is: Firebird-1.5.3.4870-0-Win32.exe
Pretty old .. been using 2.nn for over a year now.
I guess it was not casting the date into a timestamp and so gave a null value.
Graham:Pretty old .. been using 2.nn for over a year now.I guess it was not casting the date into a timestamp and so gave a null value.
Any upgrade suggestions ? Uninstall ... Install ?
I'd like to use the version you are using.
http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb212_release
Should this worry me ?
No, it should not be a problem.
the benefit of using 2.1 is nbackup which provides differential backups - though this was broken in 2.1 and was supposed to be fixed in 2.1.1
which version are you using ?
How about this one ?
http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb204_release
2.0.4 ?
I'd go for a newer version.
alter table vaccinations alter column vdate type timestamp
to reverse ?
No, no need as I am not actually asking the user to enter hours:mins:secs:tz data so leave it as date field.
In fact the next server will do this for them ie swap over to date field.
If anyone has <null> in the vdate of the immunizations,
use IBO console command
update vaccinations set vdate = 'NOW' where vdate is null
to chage the null to today.