sql function fot removing negative sign
-
0:-13:-16 Please help me to remove the negative sign.I have to get output as 0:13:16
-
0:-13:-16 Please help me to remove the negative sign.I have to get output as 0:13:16
Are you asking for something as simple as string functions such as SQL Server's Replace()? Depending on which database you're using, I'd google "your_database string functions"...
Data Quality Tools and Decision Tree software
-
0:-13:-16 Please help me to remove the negative sign.I have to get output as 0:13:16
So are you still storing your date data as strings? Or have you done the sensible thing and changed it to a datetime format. Sorry I already know the answer otherwise you would not be asking this question. CHANGE YOUR DATE DATA TO DATATIME FORMAT!
Never underestimate the power of human stupidity RAH