how to remove milliseconds

[uthpalaw]

Hi,

I have a datetime data type column which stores date and the time with milliseconds. Is there any sql query to select the date and time without milliseconds ?

for exa : suppose i have this value - 2011-02-24 08:52:26,610

when i run the select query i need 2011-02-24 08:52:26 (without milliseconds)

Thanks,
Uthpala

[lovelesh]

you can specify the format of timestamp in select query.

use DATE_FORMAT function in MYSQL
use to_timestamp function in Oracle

[masijade]

use to_timestamp function in Oracle

I believe you mean to_char. ;-)

You use to_timestamp to create a timestamp from text.

[Tolls]

If this is simply for display purposes I'd take the datetime in the select and simply use a SimpleDateFormat for display. That way you have no db-specific SQL in your code.