• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 586
  • Last Modified:

Convert Oracle TimeStamp to SQL Server SmallDateTimeStamp

Can someone tell me how to convert Oracle TimeStamp data type into a format that SQL Server 2008 can allow an insert into a smalldatetime data type column?

Thanks
0
jeffreyjseaman
Asked:
jeffreyjseaman
1 Solution
 
slightwv (䄆 Netminder) Commented:
Using to_char you can convert the Oracle timestamp to a string in whatever format you want:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions200.htm

Thre format values are here:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements004.htm#CDEHIFJA
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now