i have one time field column like 12.00 AM
i want chang into railway time.
i need to find last count value while inserting new record in the table
how can i extract some string in the following column
<br /><br />i have one problem in converting char to smalldatetime<br />that is 000002--->convert into HH;MM;SS<br /><br />declare @time...
that data can be fetched from table <br />while trying this code i got error<br /><br />declare @newtime varchar(20),@ttime varchar(20)<br />set...
<br /><br />i have one problem <br /><br />i want to convert char '164910' to '16:49:10' time format that's hh:mm<img...
Separate names with a comma.