How to merge date and time in FoxPro Query

hello 

i have the following table which im trying to read in foxpro cause its a dbf file.

i need to get the latest time for the current date so i know which id belongs to it.

foxpro doesnt allow the getdate() function

how can i join the date and time so it looks like '2014-07-15 08:00:00' into one column so i can perform a datetime function on it?

thanks