Recent Comments
- HunterCobra on Brother 2040 Toner Light Stuck
- stokeontrentuk on Brother 2040 Toner Light Stuck
- hecticmum on Brother 2040 Toner Light Stuck
- bert hubert on Brother 2040 Toner Light Stuck
- Anon on Brother 2040 Toner Light Stuck
Archives
- February 2011 (1)
- April 2010 (1)
- February 2010 (1)
- January 2010 (2)
- November 2009 (4)
- October 2009 (5)
- September 2009 (4)
- August 2009 (3)
- July 2009 (1)
- June 2009 (2)
- April 2009 (2)
- March 2009 (3)
- February 2009 (4)
- January 2009 (4)
- December 2008 (3)
- November 2008 (7)
- September 2008 (5)
- August 2008 (1)
- June 2008 (1)
- May 2008 (3)
- April 2008 (1)
- March 2008 (1)
- February 2008 (1)
- January 2008 (5)
- December 2007 (2)
- November 2007 (1)
- October 2007 (3)
- August 2007 (1)
- July 2007 (1)
- June 2007 (3)
- May 2007 (8)
- April 2007 (5)
- March 2007 (5)
- February 2007 (7)
- January 2007 (1)
- November 2006 (2)
- December 2004 (1)
- October 2004 (1)
- September 2004 (2)
- August 2004 (2)
- July 2004 (5)
- June 2004 (3)
- May 2004 (6)
- April 2004 (3)
- March 2004 (5)
- February 2004 (8)
- January 2004 (17)
db2 Archive
-
Pad a Numeric Field with 0 in DB2
Posted on June 10, 2009 | 1 CommentSay you’re storing a time in a 6 position numeric field in DB2 (in HHMMSS format), and you need to pull the hour. SUBSTR(FIELD,1,2) will work great as long as...
