I have a string date in the format DD/MM/YY (16/07/13) How do I convert this string date to SQL Date format (maintaining the same DD/MM/YY format) for storing i
I have one requirement START_DATE : 03/01/2018 END_DATE : 31/01/2018 I need a query which will list all the weeks starting date and end date between these two
I want to use S&P500 company information to calculate an index. However, the companies in S&P500 changes frequently, I want to know the constituents for
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
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
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
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
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
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
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
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?)
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
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
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
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
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 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
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
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
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