-
MY PROJECTS
-
Recent Posts
- SQL.How can you compare two nullable values safely, and how does IS DISTINCT FROM differ from <>?
- SQL.How are NULL values ordered by ORDER BY, how do defaults differ between databases, and how can you control their placement?
- SQL.How does NULL propagate through arithmetic expressions, and how can COALESCE and NULLIF help handle missing values and division by zero?
- SQL.How does NULL affect join conditions, and why can filtering the right-hand table in WHERE remove unmatched rows from a LEFT JOIN?
- SQL.How do GROUP BY and DISTINCT treat NULL values, even though NULL = NULL evaluates to UNKNOWN?
- SQL.How do aggregate functions handle NULL, and what is the difference between COUNT(*), COUNT(column), and COUNT(DISTINCT column)?
- SQL.How does NULL affect IN and NOT IN, and why can NOT EXISTS be a safer choice when a subquery returns nullable values?
- SQL.How do WHERE, HAVING, and CHECK constraints treat conditions that evaluate to UNKNOWN?
- SQL.Why do column = NULL and column <> NULL not work as expected, and when should you use IS NULL and IS NOT NULL?
- SQL.What is SQL’s three-valued logic (TRUE, FALSE, UNKNOWN), and how do AND, OR, and NOT behave with UNKNOWN?
- ChromeDevTools.Watch all failed requests
- SQL.What are domain types (or constraints on data types), and how do they help enforce data correctness?
- SQL.How does SQL handle comparisons between different data types (for example, string vs number), and why is this dangerous?
- SQL.What is the difference between DATE, TIME, TIMESTAMP, and TIMESTAMPTZ, and which one should be used for business events?
- SQL.How do numeric types like INTEGER, BIGINT, DECIMAL, and FLOAT differ in terms of precision and use cases?
- SQL.What problems can arise from implicit type casting in SQL, and how can it affect indexes?
- SQL.How does NULL differ from 0, an empty string, or FALSE in SQL?
- SQL.What is the difference between CHAR, VARCHAR, and TEXT, and when would you choose each?
- SQL.What is MVCC ?
- SQL.What is AutoVacuum Postgres ?
Categories
- Aptana
- Azure
- C#
- DataSnap
- DBExpress
- Delphi
- Delphi и сети
- Delphi. Язык программирования
- ExtJS
- FastReport
- FireDAC
- FireMonkey
- GIT
- ICS
- IDE
- IIS
- Indy
- InnoSetup
- javascript
- jQuery
- JSON
- LiveBindings
- MSHTML
- MySQL
- PHP
- REST
- Ribbons
- SMS
- SQL инструкции
- SVN
- TRichView
- UniGui
- WebBroker
- WinAPI
- Windows
- Алгоритмы
- Без рубрики
- Деревья
- Ищу ответ
- Компонентостроение
- Мои компоненты
- Начальный уровень
- Обработка исключений
- Парсинг
- Потоки(Threads)
- Регулярные выражения
- Тестирование приложений
Author Archives: Stanislav_Panteleev
Java.Java8.How to get current time in local time with millisecond precision using Date Time API?
Let’s now get the current local time (i.e., your system time zone) with millisecond precision using the Java 8 Date Time API. ✅ Best Way: Use LocalTime.now() + Format with .SSS 🔹 Output: 🔧 Why It Works: Part Description LocalTime.now() … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.How to get current time in local time with millisecond precision using Date Time API?
Java.Java8.How to get current time with millisecond precision using Date Time API?
✅ Use LocalTime.now() or LocalDateTime.now() 🔹 Example with LocalTime: 🔹 Output: ✅ More Common: Use LocalDateTime (includes date too) 🧠 Want to Extract Just the Milliseconds? ⚠️ getNano() returns nanoseconds — we divide by 1,000,000 to get milliseconds. 🔸 Optional: … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.How to get current time with millisecond precision using Date Time API?
Java.Java8.How to get second Saturday of current month using Date Time API?
✅ Step-by-step Approach Get the first day of the current month Use TemporalAdjusters.dayOfWeekInMonth(2, DayOfWeek.SATURDAY) to find the 2nd Saturday ✅ Full Example: 🔹 Output Example (assuming today is April 15, 2025): 🧠 Tip: If you want the first Monday, third … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.How to get second Saturday of current month using Date Time API?
Java.Java8.How to get next Tuesday using Date Time API?
✅ Use TemporalAdjusters.next(DayOfWeek.TUESDAY) 🔹 Output Example: 🔸 Bonus: If Today Is Tuesday and You Want the Next One TemporalAdjusters.next() → always moves to the next one, even if today is Tuesday TemporalAdjusters.nextOrSame() → includes today if it’s already Tuesday
Posted in Без рубрики
Comments Off on Java.Java8.How to get next Tuesday using Date Time API?
Java.Java8.How to add 1 week, 1 month, 1 year, 10 years to current date using Date Time API?
🗓️ Java 8’s java.time API makes adding time units to dates super clean and readable using methods like .plusWeeks(), .plusMonths(), .plusYears().
Posted in Без рубрики
Comments Off on Java.Java8.How to add 1 week, 1 month, 1 year, 10 years to current date using Date Time API?
Java.Java8.How to get current date using Date Time API from Java 8?
✅ Ways to Get the Current Date 🔹 1. Using LocalDate If you want just the date (without time):
Posted in Без рубрики
Comments Off on Java.Java8.How to get current date using Date Time API from Java 8?
Java.Java8.What is ZonedDateTime?
⏰ Let’s talk about ZonedDateTime, the most precise and complete date-time class in Java 8’s java.time package. ✅ What is ZonedDateTime? ZonedDateTime is a class that represents: 📅 Date + 🕒 Time + 🌍 Time Zone 🔹 Example: It contains: … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.What is ZonedDateTime?
Java.Java8.What are terminal methods and what are not ?
✅ 1. Intermediate Methods (NOT terminal) These build up the stream pipeline Lazy – they don’t do anything until a terminal method is called Always return a Stream (or IntStream, etc.) 🔹 Examples: These methods transform the stream and are … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.What are terminal methods and what are not ?
Java.Java8.✅ What Is LocalDateTime?
LocalDateTime represents a date and time without a time zone — basically a timestamp like: It combines: LocalDate → date (year, month, day) LocalTime → time (hour, minute, second) 🔹 When to Use It Use LocalDateTime when: You need a … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.✅ What Is LocalDateTime?
Java.Java8.What additional methods for working with associative arrays (maps) appeared in Java 8?
Java 8 brought some powerful new methods to Map that made working with associative arrays (maps) much cleaner, safer, and more expressive. 💡 Let’s go over the most useful ones: ✅ New Map Methods in Java 8 Method Purpose getOrDefault() … Continue reading
Posted in Без рубрики
Comments Off on Java.Java8.What additional methods for working with associative arrays (maps) appeared in Java 8?