you can use to_char(timestamp,'mm-dd-yyy') where timestamp is your couln
name. You can place this in your select section.
enzo venegas palacios wrote:
hi, my problem is very basic (and my english too)
i have a variable with a date (timestamp format)
$fecha = mm-dd-yyy hh:mm:ss
i need to display only the date and not the hour
$only_date = ??? ($fecha);
echo $only_date;
display = mm-dd-aaaa
enzo
---------------------------------------------------------
Redecora tu móvil. Redecora tu vida. ¿Por qué no? Con http://logos.ya.com es posible
ADSL + Llamadas 24 horas: desde 28,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
