GitHub

06_V_SQL functions - date and string functions, case when.sql

DATEPART(WEEKDAY,order_date) as order_week_day, DATEADD(day,5,order_date) as new_order_date, DATEADD(year,5,order_date) as new_order_year, DATEADD(year,-5,order_date ...
Hacker

SQL Window Functions: A Quick Review With Examples

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...
GitHub

Day3_date_time_function.sql

select date_format(now() ," %a %M") from dual; # %c and %m same select date_format( now(),"current hour is %h ") from dual; # % h is number of hour ...
IEEE

Repairing Regex-Dependent String Functions

Abstract: Regex-dependent string functions are string functions that take regular expressions (regexes) as parameters and are popular means of manipulating strings. They are frequently used for, e.g., ...
Geeky Gadgets

Master Date Functions in Excel to Save Huge Amounts of Time

If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this knowledge ...
findnerd.com

REPLACE(str,from_str,to_str) string function in MySQL

When you want to replace a string from other string in a string then you can use REPLACE function. REPLACE function returns the string str with all occurrences of the string from Str and replace it by ...
Hacker

Python: Effective Techniques for Managing Dates in DataFrame

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...