Código SQL [-] select cast(campoFechaHora as Date) as Fecha, cast(campoFechaHora as Time) as Hora from laTabla
select cast(campoFechaHora as Date) as Fecha, cast(campoFechaHora as Time) as Hora from laTabla