• C# Linq double groupby need min/max for hourly values once per day 2018-06-12

    I have been playing around with this for awhile now and can't quite get the result I am looking for. I have an object like this: public class Point { public string Tag {get;set;} public DateTime Time {get;set;} public int Value {get;set;} } Each tag

    Tags: linq, date
  • How do I find "origin" of a Date in R 2018-04-29

    If I have a date that i've converted using the as.Date function, e.g. "2015-01-01" how can I find out what date it is using as reference for its origin? And yes, I tried ?Date, and tried using the default origin, but got days in 1945. I would li

    Tags: date
  • Sending date query to database 2018-04-12

    $date = getdate(); $query = "UPDATE Members Set Name = '$desiredName', Latest_Update = '$date' Where ID = '$currentID'"; if(sqlsrv_query($conn, $query)) { echo "Record successfully updated."; } I have this query to update a name of a m

    Tags: php, mysql, date
  • Converting minutes and hours into text representations in Java? 2018-04-02

    I'm using the SimpleDateFormat and Date class to get the current time. The watch face I am developing for Android wear requires the text version of the time. For example, 8:30 would be "eight" and "thirty", 9:21 would be "nine&quo

    Tags: java, date, class, android, simpledateformat
  • RegEx Notepad++ Python Script to change Date Format 2018-03-23

    Gang...I need a notepad++ python script teaching moment. I want to find and replace a date format (MM/DD/YY and replace with YYYY-MM-DD). In NotePad++ RegEx I can do this with Find: (([0-9]+)/+([0-9]+)/+([0-9]+)) Replace: 20\3-\1-\2 Would someone sho

    Tags: regex, python, date
  • Javascript, advancing date range 2018-03-12

    I using a date-picker to set a start and end date. The date range is supposed to move forward each day for a two week, sliding window of entry. My code below works but I would like to refactor it into something that is easier to maintain. What techni

    Tags: javascript, date, jquery
  • how to convert date format in php 2018-02-19

    This question already has an answer here: Convert date format yyyy-mm-dd => dd-mm-yyyy 11 answers I tried to convert date format which is store in databaseas '2015-04-20' to '04-20-2015'.Now I caught garbage value in date_format(). echo $dob1=$vfet['

    Tags: php, date
  • Java Collection Using Date Sorting on Same Date with AM/PM 2018-01-31

    I have Date as listed below: 17/03/2015 09:38:39 AM 17/03/2015 10:52:26 AM 10/03/2015 08:30:56 AM 02/03/2015 09:18:10 AM 02/03/2015 09:37:23 AM 02/03/2015 11:25:01 AM 02/03/2015 11:29:00 AM 02/03/2015 11:42:38 AM 02/03/2015 12:04:39 PM 02/03/2015 12:

    Tags: java, date
  • Java date issue while storing and querying? 2017-12-20

    I am using Java 1.7 and mysql database. mysql db is set to UTC timezone. I have below code to save the date into db. While saving I am using new java.util.Date() If I want to search by Date range through UI, I have below code. Javascript file: var be

    Tags: mysql, java, date, datetime, hibernate
  • Need batch file to rename files with last month's date to this month's date 2017-11-30

    Most of what I can find on here is appending the date to a filename, but I need to drop last month's date and then append this month's date. I've got the date part figured out, but I just need help with the rename portion. The variables in the batch

    Tags: date, batch file, rename
  • Issue with javascript linear calendar 2017-10-08

    I'm making a simple linear calendar. I managed to display all days of current month and the week names. But also i'm need to display all days of next month with week names. But I can't get the solution. If anyone can help me with this problem and imp

    Tags: javascript, date, calendar
  • MySQL fill empty dates 2017-09-25

    I have been trying to get my head around this for a time now and can't find a solution: I am querying for time-entries with a result like this: 2015-02-10: 13 2015-02-11: 16 2015-02-13: 11 As you can see I am missing two days in the array because the

    Tags: php, mysql, date
  • dijit/form/DateTextBox not correctly parsed 2017-07-06

    What can be the reason of a dijit/form/DateTextBox not correctly parsed ? Here is the scenario : I have a page where a following control is correctly rendered : Then the user can be redirecter to another page, and we store the date he selected on the

    Tags: javascript, date, dojo
  • SQL display months when Count is 0 2017-07-04

    This question already has an answer here: Include monthly counts including months where data doesn't exist 1 answer I was wondering if someone could help me... I have the following SQL query (have shortened this down as its a large union query) SELEC

    Tags: sql, date, count, sql server 2008 r2, datepart
  • Get next occurrence of day and hour in javascript 2017-05-09

    I am attempting to implement a countdown timer to a specific point in time in the future. This point in time is always the same day of the week and hour, and is based on UTC time. I am attempting to write a general function that given a day of the we

    Tags: javascript, date
  • Minutes formatting issue in Query date time picker 2016-11-26

    I am new to jQuery but I have been programming for more than two years in C#. I am developing a MVC project, there I have implemented a jQuery date time picker that would be used for get the user input for start date. I thought that I created the pro

    Tags: date, jquery, datetime format, jquery plugins, datetimepicker
  • Fields getting removed when updatating mongodb document 2016-11-13

    I'm new to mongoDB and I have stumbled over some update issues when using Save(). When I click the save-button in my html-page I run the following code: <?php $action = (!empty($_POST['btn_submit']) && ($_POST['btn_submit'] === 'Save')) ? 'save

    Tags: date, save, mongodb, mongodb php
  • Oracle SQL TOAD - Update Year in a variable ( Concat string + Year ) depending of Sysdate 2016-09-30

    I would like to Update Year in a variable ( string + Year ) depending of Sysdate I want to execute a 'select' command more or less like that : If sysdate is between 1st of October and 31 December select * from table where between CONCAT ('

    Tags: sql, date, oracle, concatenation
  • Parse 10^-7 using SimpleDateFormat 2016-09-29

    I'm trying to parse a set of dates using java's SimpleDateFormat. For example: 2015-05-05T13:53:00.0000000 2015-05-05T09:38:00.0000000 2015-05-05T00:33:00.0000000 2015-05-04T18:18:00.0000000 This is the pattern I have so far yyyy-MM-dd'T'HH:mm:ss.SSS

    Tags: java, date
  • How to get week start date Sunday and week end date Saturday in php 2016-07-25

    How to get week start date Sunday and week end date Saturday in php. I try my self below to code am getting Week Start Date as Monday Week End Date as Sunday. $cdate = date("Y-m-d"); $week = date('W', strtotime($cdate)); $year = date('Y', strtot

    Tags: php, date

Copyright (C), All Rights Reserved.

processed in 3.211 (s). 9 q(s)