Re: Concatenate

From: Reiro <ReiroGP_at_gmail.com>
Date: 16 Mar 2006 05:49:37 -0800
Message-ID: <1142516977.224799.24460@j52g2000cwj.googlegroups.com>

55000 is the format i am gettin the time in. the format should ideally be as 05:50:00.
in another column i have a date 16/03/2006. now in a third colum i want to have the date and time concatenated so it appears as timestamp. EXAMPLE: 16/03/2006 05:50:00 Received on Thu Mar 16 2006 - 07:49:37 CST