i have the source column with date in the format of 2007-07-08 00:00:00.000 how can i get just the date from it and leave out the time part at the target column...
thanks
how to get date from date time
Moderators: chulett, rschirm, roy
If it's a string (Char/VarChar) datatype, just use the left() function
If it's a timestamp datatype, use TimestampToDate()
Both in transformer and both are <a href="http://publib.boulder.ibm.com/infocente ... umented</a> in the IIS Information Center and the Parallel Job Developer's Guide.
Regards,
If it's a timestamp datatype, use TimestampToDate()
Both in transformer and both are <a href="http://publib.boulder.ibm.com/infocente ... umented</a> in the IIS Information Center and the Parallel Job Developer's Guide.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.