I have datetime value as "mm/dd/yyyy h:m:s", my question is as title. help pls!
Cheers,
Elton
SUBSTRING(<your-value>, 1, 2)
-Jamie
|||use DATEPART function in expressions|||
If the source column is a date type, such as DT_DBTIMESTAMP, then you can use the date related functions, DATEPART, or there is also a more direct MONTH function.
Integration Services Expression Reference
(http://msdn2.microsoft.com/en-us/library/8b80403f-6d45-4001-8b12-25a933c663a2.aspx)
No comments:
Post a Comment