Posts

Showing posts with the label SQL Date function

Featured Post

Python Regex: The 5 Exclusive Examples

Image
 Regular expressions (regex) are powerful tools for pattern matching and text manipulation in Python. Here are five Python regex examples with explanations: 01 Matching a Simple Pattern import re text = "Hello, World!" pattern = r"Hello" result = re.search(pattern, text) if result:     print("Pattern found:", result.group()) Output: Output: Pattern found: Hello This example searches for the pattern "Hello" in the text and prints it when found. 02 Matching Multiple Patterns import re text = "The quick brown fox jumps over the lazy dog." patterns = [r"fox", r"dog"] for pattern in patterns:     if re.search(pattern, text):         print(f"Pattern '{pattern}' found.") Output: Pattern 'fox' found. Pattern 'dog' found. It searches for both "fox" and "dog" patterns in the text and prints when they are found. 03 Matching Any Digit   import re text = "The price of the

SQL: 8 Frequently Used DATE Functions

Image
SQL DATE function for all Developers. DATE Function is powerful in SQL. In SQL projects, people use this Function variety of ways. All projects depends in DATE, and without it there is no way of existing of project.  The Quick tour helps you use this function effectively.  You can learn Oracle SQL step by step for all Developers. Below is the list of SQL DATE functions SYSDATE - It returns current local DATE and Time CURRENT_DATE - Return local DATE and TIME and adjusted to current session Time Zone. ROUND (DATE) - Rounds to nearest DAY TRUNC (DATE) - Truncates Time MONTHS_BETWEEN(date1,date2) - Returns number of months between date1 and date2' LAST_DAY(DATE)- Returns last of the month ADD_MONTHS(date,integer_months) - Adds specified number of months to specified date. NEXT_DAY(date, day_of_week) - Returns to next day of the week that comes after the specified DATE Also Read   The Best SQL Book for all Developers.