Posts

Showing posts with the label SQL Date function

Featured Post

Python Set Operations Explained: From Theory to Real-Time Applications

Image
A  set  in Python is an unordered collection of unique elements. It is useful when storing distinct values and performing operations like union, intersection, or difference. Real-Time Example: Removing Duplicate Customer Emails in a Marketing Campaign Imagine you are working on an email marketing campaign for your company. You have a list of customer emails, but some are duplicated. Using a set , you can remove duplicates efficiently before sending emails. Code Example: # List of customer emails (some duplicates) customer_emails = [ "alice@example.com" , "bob@example.com" , "charlie@example.com" , "alice@example.com" , "david@example.com" , "bob@example.com" ] # Convert list to a set to remove duplicates unique_emails = set (customer_emails) # Convert back to a list (if needed) unique_email_list = list (unique_emails) # Print the unique emails print ( "Unique customer emails:" , unique_email_list) Ou...

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.