All Questions
246 questions
0
votes
1
answer
141
views
Looker - How to Compare today data with last week data but including hours
I need to find out how to compare today data with last week data in lookerstudio.
Example:
Today 01/11/2024 16.00 PM # of order is 2255
Last week 25/10/2024 16.00 PM # of order is 2190
I need to ...
- 39
0
votes
1
answer
76
views
Last Sunday until this upcoming Sunday with time
I am trying to retrieve the last recent Sunday at 3 AM until this upcoming Sunday 2:59 AM.
Below is what I have but it doesn't retrieve exactly the upcoming Sunday. Ideally, whenever I run this query, ...
- 79
1
vote
0
answers
66
views
Moving Records based on Type, Confirmation Date, Type Table Hours Offset and working Calendar Date
I have been attempting to automate my Order movement process in SQL Server 2014 by having it look for these criteria;
Order Type (Green, Blue, Purple)
Confirmation Date (FIRST Date that a ...
0
votes
1
answer
45
views
How to compare current time to specified time of day and day of the week in PostgreSQL?
I have a table of accounts and want to make it possible to specify allowed time for logging in for each of them, something like "9:00-19:00, mon-fri", so that later it was possible to check ...
- 3
0
votes
1
answer
211
views
Subtract to numbers in relation to time/date specific query in Mysql // Nodered
hy, beeing a noob in mysql i am trying to substract two numbers in relation to a time/date specific query:
Trying to display the actual daily power consumption of my house i can extract the total ...
- 51
1
vote
3
answers
2k
views
Snowflake converting numeric value into HHMMSS format
I have a column that has number in it in the format of HHMMSS but the number is not consistent (not all have six digits), ex: "83455" "153651" "91251".
The number 83455 ...
- 51
0
votes
2
answers
163
views
Current date and time in Oracle SQL
I want a SQL query to show the current date and time.
I have tried
SELECT CURRENT_TIMESTAMP; --"FROM keyword not found where expected"
SELECT GETDATE(); --"FROM keyword not ...
0
votes
0
answers
654
views
Convert 10 digit number from Legacy system to Date in SQL
I am converting data from a legacy system to SQL. I got to convert a 10 digit number (e.g. 1419120000) to SQL DateTime. I am able to do so using dateadd(second,1419120000,'1970-01-01'). This function ...
- 33
-1
votes
1
answer
55
views
CONCAT two newly created date and time fields in the same query
I have parsed two separate date and time fields from STRINGS to DATES and TIME (see below)
SELECT
safe.parse_date('%Y%m%d',Arrival_Date) eventdate,
safe.parse_time("%H:%M",Arrival_Time) ...
- 77
-1
votes
1
answer
171
views
MS Access form date range of single date yields no results
The form uses begin date and end date text boxes formatted as "General Date" to filter results. They are generally filled using the calendar date picker tool as format m/d/yyyy. ODBC SQL ...
- 19
-2
votes
1
answer
47
views
Find elements between date and time intervals MySQL
How do I query a SQL Database to search trough a date and time interval when I have different columns for date and time ?
SELECT * FROM prices.prices WHERE data BETWEEN CAST('2020-01-06' AS DATE) AND ...
1
vote
2
answers
319
views
Java SQL cant insert Date and Time
I keep getting this error
class java.time.format.Parsed cannot be cast to class java.time.LocalDate (java.time.format.Parsed and java.time.LocalDate are in module java.base of loader 'bootstrap')
I am ...
0
votes
1
answer
355
views
QlikView Convert 1753-01-01 00:00:00.000 to NULL
I am trying to convert data from SQL as 1753-01-01 00:00:00.000 to be shown as NULL values in QlikView.
I do the following in the QlikView Load statements -
SET NullTimeStamp = if ($1 = '1753-01-01 ...
- 13
0
votes
1
answer
1k
views
How to convert text to date (YYYY-MM-DD format) in SQLite
So i have a table named 'employe' with the column 'employee_hire_date' (type text, DD-MM-YYYY format) and i want to format all the data to date type, or at least change the format with an update to ...
- 3
0
votes
1
answer
38
views
SQL Query to copy field and split in to 2
hi I'm new to sql im trying to copy a field in SQL table to then split the date and time out
Column name :- DocumentDate
date I want to split:- 2020-02-12 00:00:00.000 into a new field called DATE , ...
