Hi
I have an old database that stores dates as floats and I need to change 2 records on one of the tables and the front end generates an error. As it is only 2 records, I have suggested, to save time at least, that I manually amend the SQL record!
Unfortunately I do not know how to convert the date to the float!
I have an example from the database that has 3599164800 stored, which displays a date of 2018-01-19 00:00:00
I want the date to display 2018-02-05 00:00:00, how do I get the 'float' value please?
Thanks
Steve
I have an old database that stores dates as floats and I need to change 2 records on one of the tables and the front end generates an error. As it is only 2 records, I have suggested, to save time at least, that I manually amend the SQL record!
Unfortunately I do not know how to convert the date to the float!
I have an example from the database that has 3599164800 stored, which displays a date of 2018-01-19 00:00:00
I want the date to display 2018-02-05 00:00:00, how do I get the 'float' value please?
Thanks
Steve