[SQLITE3]How to retrieve the Date part out of a Datetime result column?

[tyler666]

I have a column of date time which i would like to retrieve only the date. Is there anyway to do this?Previously it was an epoch value where i convert it to datetime .Following is a sample result :\[code\]smbd|ip address|1082|ip address|"2011-04-26 18:40:34"\[/code\]I have tried the following commands but has yield negative / zero results\[code\]SELECT DATE(datetime) from attacked_total;SELECT STRFTIME('%Y-%m-%d', datetime) FROM attacked_total;SELECT DATETIME('%Y-%m-%d', datetime) FROM attacked_total;SELECT DATE('%Y-%m-%d', datetime) FROM attacked_total;\[/code\]thanks for any help given. most appreciated