dynamicjourney
Programmer
Hi,
What would be problems that will occur if the date field has data and then convert it to timestamp datatype?
D
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Modify existing date datatype to timestamp
- Thread starter dynamicjourney
- Start date
- Status
Hi,
What would be problems that will occur if the date field has data and then convert it to timestamp datatype?
D
No problem, just issue:
Code:
ALTER TABLE MyTable MODIFY (date_field TIMESTAMP);![[3eyes]](/data/assets/smilies/3eyes.gif "[3eyes] [3eyes]")
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
- Status
Similar threads
- Locked
- Question