Date format2

SELECT
o.name as table_name,
c.name as column_name,
t.name as sybase_data_type,
CASE
WHEN t.name IN ('datetime', 'smalldatetime', 'datetimn') THEN
'TIMESTAMP "Mon DD YYYY HH:MI:SSAM"'
WHEN t.name = 'bigdatetime' THEN
'TIMESTAMP "Mon DD YYYY HH:MI:SS.FF6AM"'
WHEN t.name LIKE '%char%' THEN
'CHAR(' + CONVERT(varchar, c.length) + ')'
WHEN t.name LIKE '%int%' THEN
'NUMBER'
ELSE
'/* MAP ' + t.name + ' MANUALLY */'
END as oracle_mapping,
c.colid as column_position
FROM sysobjects o, syscolumns c, systypes t
WHERE o.id = c.id
AND c.type = t.type
AND o.type = 'U'
ORDER BY o.name, c.colid