python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - date

Get the max date of dates in a column that are > than 6 days prior to another date column

I have data where I want to compare what date was given 6 days or more prior to another date. Example: the actual date time is 15th Jan 2022, I would like to see what the estimated time was 6 or more ...
test-img

T walker

sql

date

amazon-redshift

Votes: 0

Answers: 1

Latest Answer

worked it out by reading more SELECT foe.load_id, foe.estimated_arrival_time eta, fol.pod_vessel_arrival_time ata, foe.event_date_time, foe.shipper, foe.carrier, fol.load_n...
test-img

T walker

set date format for knitr document

Is there a way to set a global option (either through options() or knitr::opts_chunk$set() or something else) to set all dates in a knitr/Rmd document to be formatted in a particular style. So instead...
test-img

vorpal

r

date

format

r-markdown

knitr

Votes: 0

Answers: 2

Latest Answer

Following the R Markdown Cookbook you could achieve your desired resulting via a custom knit_print method. To add some flexibility you could add the date format as a parameter in the YAML header which...
test-img

stefan

How can i concat Year, day, Hour and minute of a Dataframe

I had a Dataframe with this kind of date Year Day Hour Minute 2017 244 0 0 2017 244 0 1 2017 244 0 2 I want to create a new column on this DataFrame showing the date +hour minute but I...
test-img

Miguel Ribeiro Godoy

python

pandas

dataframe

date

Votes: 0

Answers: 3

Latest Answer

Try: s = pd.to_datetime(df['Year'], format='%Y') \ + pd.TimedeltaIndex(df['Day']-1, unit='D') print(s) # Output 0 2017-09-01 1 2017-09-01 2 2017-09-01 dtype: datetime64[ns] Now you can ins...
test-img

Corralien

Use one of two dates in where clause

I need to delete all records in a table where the CreatedDate or ModifiedDate is greater than x. The logic is as follows: If ModifiedDate is not null then use this value Otherwise use the CreatedDate...
test-img

Newman

sql

date

where-clause

Votes: 0

Answers: 2

Latest Answer

Use case statment Delete * From tableX CASE WEHN ModifiedDate is not null and < Getdate() - 30 THEN -- your logic Else -- CreateDate < Getdate() - 30 END
test-img

user123456

Posts

Questions

Blogs

Jobs