date Questions
12
Solved
I have a table with dates that all happened in the month November.
I wrote this query
select id,numbers_from,created_date,amount_numbers,SMS_text
from Test_Table
where
created_date <= '2013-...
Rodrich asked 12/11, 2013 at 8:27
5
I want to get the set of years which pertain to a specific date, week of the day and month. There are possibilities that I can get various years from this pattern. Suppose Date is 15, Month is Augu...
6
Solved
is there any function to check if a given date is valid or not?
I don't want to write anything from scratch.
e.g. 32/10/2012 is not valid
and 10/10/2010 is valid
29
Solved
I have an annoying bug in on a webpage:
date.GetMonth() is not a function
So, I suppose that I am doing something wrong. The variable date is not an object of type Date. How can I check for a ...
Yakutsk asked 13/3, 2009 at 17:31
47
Solved
SELECT GETDATE()
Returns: 2008-09-22 15:24:13.790
I want that date part without the time part: 2008-09-22 00:00:00.000
How can I get that?
Sanctus asked 22/9, 2008 at 3:31
17
Solved
I'm trying to write a regular expression that validates a date. The regex needs to match the following
M/D/YYYY
MM/DD/YYYY
Single digit months can start with a leading zero (eg: 03/12/2008)
Singl...
34
Solved
How do you display a JavaScript datetime object in the 12 hour format (AM/PM)?
Strother asked 17/1, 2012 at 1:7
4
I was just wondering, in Windows 7 and above, is it possible to change the way dates and times are displayed via the command prompt? Yes, I'm in the U.S. but I like doing things the European way:
...
Krak asked 19/4, 2016 at 18:36
28
Solved
I have the following code to do this, but how can I do it better? Right now I think it's better than nested loops, but it starts to get Perl-one-linerish when you have a generator in a list compreh...
Carchemish asked 29/6, 2009 at 20:16
3
Solved
I'm working on an application which uses Eastern time with a database set to Pacific time. This has been causing some issues, but we're told that it can't be any other way, so we just have to work ...
Unavailing asked 24/6, 2016 at 15:33
19
Solved
I want to get last month's date. I wrote this out:
$prevmonth = date('M Y');
Which gives me the current month/year. I can't tell if I should use strtotime, mktime. Something to the timestamp? Do...
7
The date time string is in the following format: 06/12/2012 07:21:22. How can I convert it to UNIX timestamp or epoch?
4
Solved
I am writing an app that needs to be quite accurate in dates and I wonder how can I compare LocalDate instances.. for now I was using something like:
LocalDate localdate1 = LocalDate().now();
Loca...
11
Solved
I'm looking for some succinct, modern C# code to generate a random date between Jan 1 1995 and the current date.
I'm thinking some solution that utilizes Enumerable.Range somehow may make this mor...
8
I have a standard <input /> control on my form, decorated with type="date"
When rendered, it displays the correct watermark of yyyy-mm-dd, and you can select a date correctly.
However, when ...
1
In my java application i was using REST API that returned data in JSON format, and noticed that this particular API formatted it's dates in a peculiar way: "Nov 1, 2019" , But problem is that the a...
13
Solved
Does anyone know of a Java library that can pretty print a number in milliseconds in the same way that C# does?
E.g., 123456 ms as a long would be printed as 4d1h3m5s.
6
Solved
I need this
require 'date'
DateTime.parse "Mon, Dec 27 6:30pm"
to return a DateTime for 6:30pm in the EDT timezone, but it returns one in UTC. How can I get a EST DateTime or convert the UTC o...
6
Solved
In node I can get a file's modified date using the standard file stat object. Is there a way I can also find its created date? I can't find anything in the http://nodejs.org/api/fs.html#fs_class_fs...
Tello asked 9/7, 2013 at 15:19
5
Solved
I have a string of the form "mm/yyyy" and I want to compare it against the date of the local system.
I have thought of either using a conversion table between my month and the MONTH field in Calen...
4
I am stuck in trying to find the quarter of year number from the month number i.e. i have month number 2 which should be quarter number 1, how do i do this in Access VBA or an access query?
Thanks ...
11
Solved
Problem
It looks like when I use the format() function, it automatically convert the original UTC time into my timezone (UTC+8). I have been digging through their docs for hours and couldn't seem ...
Kinzer asked 25/10, 2019 at 15:8
7
Solved
I'm having this data frame:
Name Date Quantity
Apple 07/11/17 20
orange 07/14/17 20
Apple 07/14/17 70
Orange 07/25/17 40
Apple 07/20/17 30
I want to aggregate this by Name and Date to get sum of q...
4
Solved
9
Solved
I need to get the date of the first and last day of the week knowing the week number.
I get a start date and an end date, representing the first and last day of a selected week in a given year. th...
© 2022 - 2024 — McMap. All rights reserved.