View Single Post
  #2  
Old 07-10-2007, 01:29 PM
mike mike is offline
Administrator
 
Join Date: May 2007
Posts: 273
Send a message via AIM to mike Send a message via MSN to mike Send a message via Yahoo to mike Send a message via Skype™ to mike
MySQL DATE change

One thing that you can do to MySQL is change the data type on Salesforce DATE fields, example:

Account Object:
CreatedDate column/field. I orginally setup this field as a DATE type, but you can change it to DATETIME. When you change the type, you will see a difference in your data in MySQL:

Code:
DATE type:
2007-07-10
`createddate` date default NULL,
Code:
DATETIME type:
2007-07-10 12:49:40
`createddate` datetime default NULL,

You can do this to any date field in MySQL
Reply With Quote