thank you all for your valuble comments and contribution... it all helped me to diagnose the error i was making to query my database...

vey much appreciated.

Rad

Brilliant mate...

thanks a ton...

Hi Jeff

Thanks for the reply..

Yes you are right in your analysis that first 8 digit are are date and the rest is the time. I want to extract this information...