Suppose you have an entire column in MySQL that is YYYY-MM-DD, and you want to select it as the number of Months to a specific date, and also do it as a new column. Example date counting to can be March 2020. So the following (table_1): Emp_Name Hire_Date Steve 2018-03-28 To Emp_Name Months_Employed Steve 24 …
Tag: datetime
how to check if date is within the same month as date in another column SQL BQ
I have two date fields in my BQ table. One is start_date and the other one is end_date. DataType for both columns is: DATE. Data looks like this: I need to create a new column and check if both dates are within the same month. The values would be “yes” and “no”. Yes if two dates are wi…
concatenate date + time to make timestamp
I am using dbt and snowflake to parse a json.. Currently, I parse two cols, date and time separately. Now, I want to concatenate both and assign the type timestampto them I tried this:: However, the col “REQUIRED_TIMESTAMP” is just always empty in my final table. What else can I try? Answer I assu…
Adding hours to dates in Presto
In a Presto db table, I have two string fields, a date of the form, ‘2022-01-01’, and an hour of the form, 22, for 22:00. I’m trying to combine these two elements into a proper timestamp, with date, hours, minutes, seconds. How can I accomplish this? What I’ve tried so far However, I g…
extract year_month from a date column along with other columns in a sql table
I have a sql table with multiple fields including (but not limited to the following): member_id, visit_date (in datetime format eg: 2016-01-01), visit_yr_qtr (as string, eg: 2016_Q1), purchase_item (ID number), and item_price (in US dollars). I would like to extract these fields, but also include year_month (…
Timeserial not recognized built in function in MS SQL
I am trying to implement an SQL query that gets records between today’s fixed timing 18:00 and yesterday’s fixed timing 18:00 based on a Date time column that I have in my table. I tried this query But, it’s throwing an error Timeserial is not a recognized built-in function name. Any ideas p…
Join Hours and Minute column for showing in Decimal format SQL Query
I have two datetime columns in a SQL Server table: From which I have separated hours and minutes through SQL query The output is Now, for further grouping the data, I need to join Hours and Minutes columns in one column for getting output like this Answer You can try converting both hours and mins to varchar …
Why is the SSIS variable not passing the milliseconds part into the query?
DB SETUP: SSIS: Execute SQL task: The task has an output parameter (say Param1) of data type DT_DBTIMESTAMP. The SSIS variable data type is DateTime. Then in a subsequent Data Flow Task (say TASK2), I have an OLE DB source SQL command text: The above variable is used as an input parameter. In the SQL profiler…
Assign unique id each time two fields/columns are an exact match
Big Query: I’m looking to assign a ‘unique combination id’ if a person and date are an exact match. So for each specific time a ‘person_id’ and a specific datetime are the same, they are assigned a number overall (time will always be 00:00:00 but just has to be there for records)…
Search by best values for every minute
The problem I’m having is that I have a table of data that has a new row added every second (imagine the structure {id, timestamp(datetime), value}). I would like to do a single query for MSSQL to go through the table and output only the number of objects that have the top 2 values asc for each minute (…