Question : I am not sure if I am looking at this problem the right way: I have a query […]
Tag: date-format
Does SQL Server have a Date_Format function?
Question : All I found is a list of predefined DateFormat that I can choose from, like this As I […]
How to pass, specific day month and year in the below query?
Question : I have registration according to the data in a table and I want to show the whole month, […]
Unexpected behaviour for to_date() with week number and week day
Question : I tried to convert a date string (year, week, day of week = ‘YYYY-WW-D’) into a date using […]
Calculate time difference between a datetime and the current date & time
Question : I would like to calculate the difference between a past datetime and the current datetime with the result […]
How can I correctly use the timezone format specifier in a TO_DATE call in Oracle
Question : I am trying to obtain a DATE object with the following statement: TO_DATE(‘1970-01-01 00:00:00 UTC’,’YYYY-MM-DD HH24:MI:SS TZR’) and […]
to_char(resolved_date-opened_date, ‘hh24:mi’)
Question : I am using the below to return the hh:mm difference between two date ranges. How would I update […]
Understanding datetime formats in SQL Server
Question : I’ve dealt with MS SQL Server datetime types for a long time but never thought why the following […]
How to format a date field into diferente languages in the same command? (multiple locales)
Question : The following will return the day in Italian: SET lc_time_names = ‘it_IT’; select date_format(‘2018/01/01′,’%W’) as day_italian; However I […]
Parsing COPY’s binary format to access a tsrange
Question : How is tsrange stored in binary? For example create table CREATE TABLE public.test (t tsrange); INSERT INTO test […]