>Is there a function that returns the date from a datetime expression... sort of the reverse of DTOT()? I could use something like ctod(left(str(dtoc(datetime())), 8)) but this is pretty messy and doesn't account for different SET CENTURY settings.
>
>Erik

nevermind... just found it. Just slipped my eye before... TTOD()