Amazing!! Such a good content! I will try later

Thank you so much Ken for all your help

• This reply was modified 1 year, 11 months ago by  pedroccamara.

Guys,

Got it! It works this way

TIME_TO_SEC(TT.horas)/60/60 AS TimeTT

Thanks a lot

Hello ratbak

It gives me an error code: 1582. Incorrect parameter count in the call to native function 'datediff'

I'm so sorry but I forgot to say that I'm doing this in...

It's amazing this answer!!! So simple!!

Thank you so much!!

Hello Frederico

Thanks a lot for your help

It worked perfect!!!

Hello Jeff and thank you very much for your answer.

You're right. My mistake. I thought I was in a MySql forum.

About the issue....you're sure that the function to convert that...

• This reply was modified 1 year, 12 months ago by  pedroccamara.

Found it, never mind

substring_index(TT.horas,':',1)*60+substring_index(TT.horas,':',-1),

Thanks

Hi guys,

I've just found the right solution based on Jonathan's idea

Restaurant , RIGHT(Restaurant, len(Restaurant) - charindex(' - ', Restaurant)-2) AS C

Thank you all so much, really

Hi Frederico,

I haven't missed that fact of using twice the REVERSE function but look at what I've said:

I wrote this: SUBSTRING (Restaurant, CHARINDEX ('- ', Restaurant), 20) AS Restaurant

and what...

Ok Frederico. I got this

SUBSTRING (Restaurant, CHARINDEX ('- ', Restaurant), 20) AS Restaurant

The result is this

- RestaurantName

I don't think I understood that REVERSE function because from what I've seen the...

Hi again Frederico

I guess for you it is very simple but it's not for me, as a newbie I am.

I've tried again and don't know how. Could you help?

Let me...

It's working now !!!! I forgot the  " ) dates" after END AS MM

Thank you guys so much

Thank you Frederico and Phil

Best regards

Have a great day

Hi Frederico,

I'm so sorry.

Again I thought it was obvious (my mistake) that I wanted a new date field from that concatenate.

Could you please help me then? How would you do...

Hi Phil

Thanks a lot for stepping in.

I believe I don't have that button... should I enable something, somewhere?

Hi Frederico,

Thank you so much for your answer. I got a couple of questions before my code, if this ok with you.

The first and the second CASE are DD and...