Hi,

I am new to PostgreSQL. I am trying to write a query which can give me duration of the time. In between we will get empty fields for Start Time or End time. i want to skip these rows and get the out put. Your help is appreciated.

Start_Time End_Time
20130312080535 20130312080550
20130312080018 20130312080028
20130312080030 20130312080049
20130311154049 20130311154138
20130311225510
20130311152500 20130311152538
20130311225510
20130311152539 20130311152614
20130311152740 20130311152806
20130311225510 20130311225618
20130311152450 20130311152522
20130311222800 20130311223943
20130311152707 20130311152739
20130311152523 20130311152621
20130312080000 20130312080016
20130311152126 20130311152243
20130311225510 20130311225827
20130311152622 20130311152706
20130311152245 20130311152449
20130311152740 20130311152752


Shabu224