Convert Railway Time to GMT Time in SQL query

[renuks]

In SQL Query how to Convert Railway Time to GMT Time

[azimmer]

In SQL Query how to Convert Railway Time to GMT Time

It may be my fault but I've no clue what Railway Time is. Is it http://en.wikipedia.org/wiki/Railway_time ? If you tell me what it is, I tell you how to convert it to GMT in SQL -- fair deal, isn't it? :-D

[renuks]

It may be my fault but I've no clue what Railway Time is. Is it http://en.wikipedia.org/wiki/Railway_time ? If you tell me what it is, I tell you how to convert it to GMT in SQL -- fair deal, isn't it? :-D

For Eg: when the start time is 15:30 & end time is 17:30 then how to convert it to 03:30 & 05:30 respectively

[azimmer]

For Eg: when the start time is 15:30 & end time is 17:30 then how to convert it to 03:30 & 05:30 respectively

In MSSQL:

select right(convert(varchar,myTime,100),7)
 

where myTime is of datetime and e.g. myTime=cast('17:30' as datetime)

Is it OK or you need one that conforms a standard (like SQL92)?