date formats

WITH DateTimeColumns AS (
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"'
ELSE
NULL -- Handle other data types as needed
END as oracle_timestamp_format,
c.colid as column_position
FROM sysobjects o
JOIN syscolumns c ON o.id = c.id
JOIN systypes t ON c.type = t.type
WHERE o.type = 'U'
AND t.name IN ('datetime', 'smalldatetime', 'datetimn', 'bigdatetime')
)
SELECT
table_name,
column_position,
column_name,
sybase_data_type,
oracle_timestamp_format
FROM DateTimeColumns
ORDER BY table_name, column_position;