How to get a date format like "2003-04-27 21:04:29" from ORACLE?

fux23

In oracle I have a record that has a :
2003-04-27 21:04:29
value...
but when I'm trying to get it from database:
"SELECT data from table..."
As a result I get:
03/05/04

How to get the exact data... 2003-04-27 21:04:29 not 03/05/04

Thanks

leatherback

Try the date() function:

select Date_Format(Date,'%W %M %Y') as Date from

and see http://www.phpbuilder.com/manual/function.date.php