>Hello, I'd like to extract from my SQL DB a datetime field in the format next below:
>
>dd/MM/yyyy HH:MM:SS (24hrs)
>
>How can i do this?

As others have already said it is a display format and you get a datetime from SQL server. Just use:

set date to dmy
set century on
set hours to 24

in your VFP code (if it's not VFP then other languages have similar formatting capabilities).
Cetin