Difference between revisions of "Thomas GUILLARD"
Jump to navigation
Jump to search
| Line 68: | Line 68: | ||
* ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_format_yyyy/mm SQL - Date format yyyy/mm] | * ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_format_yyyy/mm SQL - Date format yyyy/mm] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_get_'_first_day_month-1_/_last_day_month-1_/_first_day_current_month_' SQL - Date get ' first day month-1 / last day month-1 / first day current month '] | * [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Date_get_'_first_day_month-1_/_last_day_month-1_/_first_day_current_month_' SQL - Date get ' first day month-1 / last day month-1 / first day current month '] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Encode/decode_function_(base64) SQL - Encode/decode function (base64)] | * ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Encode/decode_function_(base64) SQL - Encode/decode function (base64)] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Get_difference_between_two_dates_(by_year/month/day) SQL - Get difference between two dates (by year/month/day)] | * ✅ [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Get_difference_between_two_dates_(by_year/month/day) SQL - Get difference between two dates (by year/month/day)] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Issue_with_special_char_like_$ SQL - Issue with special char like $] | * [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Issue_with_special_char_like_$ SQL - Issue with special char like $] | ||
* [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Group_several_lines_in_the_same_column_with_LIST_TAG SQL - Group several lines in the same column with LIST TAG] | * [http://thomasguillard.fr/wiki/index.php?title=SQL_-_Group_several_lines_in_the_same_column_with_LIST_TAG SQL - Group several lines in the same column with LIST TAG] | ||
Revision as of 11:15, 15 April 2022
💼Linkedin profile
🎁Github profile
👀StackOverflow activity
ACTIVE PROJECTS
ADMIN & SETUP INSTALLATION
LINUX
- LINUX - Install Apache + PHP + Oracle on RedHat7 server
- ✅ LINUX - Find and kill process locking port on Mac
MAC
- ✅ MAC - Format and set up a clean install of OS X
- MAC - Dual boot Windows10+MacOs (on older Mac 2011)
OPEN SSL
DRONE
DOMOTIC & ELECTRONICS
PHOTOS & VIDEOS
IMOVIE
SYNDICATED LOAN'S KNOWLEDGE
LOAN IQ Functional
LOAN IQ Technical
- ✅ LOAN IQ Technical - Start empush (push xml notifier)
- ✅ LOAN IQ Technical - Start accruals
- ✅ LOAN IQ Technical - Start prmtrx
- ✅ LOAN IQ Technical - Logdump
- ✅ LOAN IQ Technical - Shortcuts (into GUI client)
- ✅ LOAN IQ Technical - Add new menu item (into GUI client)
- 🚧 LOAN IQ Technical - XQuery syntaxes
CODING & CMD SAMPLES
IONIC 3
- IONIC3 - Assign content from jquery to typescrypt #hack
- IONIC3 - Solve cordova build android issue (unable to find attribute android:fontVariationSettings and android:ttcIndex)
- IONIC3 - Solve cordova build android issue (Error: spawn EACCES of gradle)
- IONIC3 - Cors issues AccessAllowOrigin
HTML 5
JAVASCRIPT
MEDIA WIKI
OPEN FACE
ORACLE SQL
- ✅ SQL - Check with regex if the string text is only composed of numbers
- ✅ SQL - Create table
- ✅ SQL - Date format yyyy/mm
- SQL - Date get ' first day month-1 / last day month-1 / first day current month '
- ✅ SQL - Encode/decode function (base64)
- ✅ SQL - Get difference between two dates (by year/month/day)
- SQL - Issue with special char like $
- SQL - Group several lines in the same column with LIST TAG