Posted by Mohd Al Junaibi on 05/23/07 06:49

Hi all...

I've got a group of tables and I wanted to first see which tables
contained a fields containing the "Date/Time" data type. And I was
successful in doing so...here's the query:


(
select a.name tablename, b.name colname
from sysobjects a, syscolumns b
where a.name = object_name(b.id)
AND B.TYPE = 61 AND A.XTYPE = 'U'

)


Now...my only issue is find which query I can run (On each table)
which returns to me ONLY the values containing the date/time stamp
with milli seconds (Ex: 01/01/2007 10:10:50:987)

I require this since we are planning on shifting those tables to the
Oracle platform, and we've had issues doing this while loading the
extracted information, since it was not taking the values containing
the "milliseconds".

Is there a way to do this? Or is it better to simply remove the
milliseconds all togeather? I wouldn't mind doing so provided that it
doesn't includes changes to the actual data type.

[Back to original message]