Category "date"

converting string to date using TO_DATE for MM/DD/YY gives wrong values for dates before 1970 [snowflake-cloud-data-platform]

Trying to convert a date string 03/31/69 to 1969-03-31 standard date format using TO_DATE function. SELECT TO_DATE('03/31/69', 'MM/DD/YY'); Expected value was

How to get exclusive date ranges?

I would like an object that gives me a date range for every month (or quarter) from 1990-01-01 to 2021-12-31, separated by a colon. So for example in the monthl

Can I convert an HTML date picker to a Hijri calendar format?

I have a small MVC 5 application which uses Arabic culture settings. I have a DateTime property in my model from this Razor syntax: @Html.EditorFor(m => m.S

Get time difference between two dates in seconds

I'm trying to get a difference between two dates in seconds. The logic would be like this : set an initial date which would be now; set a final date which woul

Laravel Carbon throws error The format separator does not match

I'm, trying to format a date into (Dayname Date Month) and I'm using Carbon for this but it return an error Carbon The format separator does not match here is a

Get current quarter in year with javascript

How can I get the current quarter we are in with javascript? I am trying to detect what quarter we are currently in, e.g. 2. EDIT And how can I count the numbe

Change AngularJS input[date] programmatically

I'm trying to assing an input[date] control an initial value in the controller. From AngularJS input[date] documentation, The model must always be a Date objec

Android - How to set a notification to a specific date in the future?

Edit: SOLVED! Ever wanted to set a notification from a specific date starting a certain point in time (when an activity is started or when a button is pressed?)

Adding The Date and Time to the File name

Hello I am trying to add the date and time to a file name in JAVA. I can get the date and time printed within the file, which I also want done, but when I place

wrong day in Android Material DatePicker

i'm trying to get te selected date from DatePicker but always i have one day less than the selected For example, if I select 14/2/2022 i obtain 13/2/2022 and if

How to convert integer into date object python?

I am creating a module in python, in which I am receiving the date in integer format like 20120213, which signifies the 13th of Feb, 2012. Now, I want to conver

How can I compare two dates in Excel VBA?

I'm working on a school project to compare if date1 is equal to date2 - 1 (date1 is one day earlier than date2). date2 is located one cell below date1. This is

compare data with month from previous year in Qlikview

I'm relatively new at Qlikview and wanted to compare some data from a selected year with its previous year. In Qlikview I have a table in which i show the coun

How convert dd/mm/yyy to date using javascript?

How do I convert the value 24/05/2016 (typeof(24/05/2016) is number) for a Date using JavaScript? While performing the following error occurs: transactionDate

Java LocalDate invalid date formatting

I have a script to get previous month for current date (script executed on 1st date monthly) the script return valid result for all other month except on Januar

Java LocalDate invalid date formatting

I have a script to get previous month for current date (script executed on 1st date monthly) the script return valid result for all other month except on Januar

CURRENT_DATE/CURDATE() not working as default DATE value

Pretty straight forward question here, I think this should work but it doesn't. Why doesn't it? CREATE TABLE INVOICE( INVOICEDATE DATE NOT NULL DEFAULT CURR

Parsing a string to a date in JavaScript

How can I convert a string to a Date object in JavaScript? var st = "date in some format" var dt = new Date(); var dt_st = // st in Date format, same as dt.

programming a journal in python without calender module. what is the most appropriate way to program dates, must be able to skip empty pages

I must build a journal, but I don't understand how to implement dates. I have to be able to sort the dates appropriately. Do I turn months into lists with every

How to convert YYYYMMDDHHMMSS to a date readable by `date`

I have a set of date/time strings in the YYYYMMDDHHMMSS format that I want to convert to something readable by the date utility. Usually, I can do something li