Post reply

How do I join month and year??

  • September 10, 2007 at 4:14 pm

    #174634

    Hi Guys

    How do i join year and month column to get a date in a formay 'yyyy/mm'

    I have got two columns like this

    Year     Month           Result Expected

    2000      1                 2000/01

    2002     12                2002/12

     

    Both year and month have 'int' data types

     

     

    Thanks

  • September 10, 2007 at 4:34 pm

    #732631

    Try converting them to varchar first...

  • September 10, 2007 at 5:00 pm

    #732637

    After that What do I do??

  • September 10, 2007 at 5:32 pm

    #732640

    Look up string concatenation in books online.

  • September 10, 2007 at 5:53 pm

    #732644

    many thanks for the very useful information

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply