Search Results

Search found 3379 results on 136 pages for 'datetime'.

Page 34/136 | < Previous Page | 30 31 32 33 34 35 36 37 38 39 40 41  | Next Page >

• Filtering a PHP array containing dates into a yearly summary

  - by privateace

  I'm looking at a way to create a summary of transactions within a certain month based on the contents of a PHP array. Intended outcome (excusing layout): ------------------------------------------- | December 2009 | 12 | | January 2010 | 02 | | February 2010 | 47 | | March 2010 …

  Read the article

• Get Template::Plugin::Date to accept MySQL dates as well as datetimes

  - by aidan

  I'm using the date plugin for Template::Toolkit (Template::Plugin::Date), it works well with datetimes (yyyy-mm-dd hh:mm:ss) pulled straight out of MySQL, but it will not work with dates (yyyy-mm-dd). What's the simplest way to get date.format to accept dates (without modifying the sql query)? Thanks.

  Read the article

• Month to Date in SQL Server 2008

  - by Aaron Smith

  Hopefully this will be an easy one to answer. I am working on a table that requires MTD data. One of our SQL guys told me to use MONTH (@monthtodate)= 11 Where @monthtodate is set to GetDate() in the parameter list in SQL Server Management Studio. So in "theory", he says, it should select the month (11) and then get today and return all the…

  Read the article

• Java simple data format british time

  - by DD

  Hi, I am using simple date format to allow users to specify which time zone they are sending data in: DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss,z"); This works fine: e.g. df.parse("2009-05-16 11:07:41,GMT"); However, if someone is always sending time in London time (i.e. taking into account daylight savings), what would be…

  Read the article

• Search Oracle date type column with hibernate, seach by everything in that day - ignore the time.

  - by Setori

  hi there <property name="batchCreatedDate" type="java.util.Date"> <meta attribute="field-description">batch create date</meta> <column name="BATCH_CREATED_DATE" length="7" not-null="true" /> </property> table column type is BATCH_CREATED_DATE DATE NOT NULL With the data in that date column…

  Read the article

• mySQL query : working with INTERVAL and CURDATE

  - by Tristan

  Hello, i'm building a chart and i want to recieve data for each months Here's my first request which is working : SELECT s.GSP_nom AS nom, timestamp, AVG( v.vote + v.prix ) /2 AS avg FROM votes_serveur AS v INNER JOIN serveur AS s ON v.idServ = s.idServ WHERE s.valide =1 AND v.date > CURDATE() -30 GROUP BY s.GSP_nom ORDER BY avg…

  Read the article

• Extract the Day / Month / Year from a Timestamp on MYSQL

  - by Tristan

  Hello, I have : $date = $actualite['date']; $actualite['date'] is a TIMESTAMP and i was wondering how i can extract from this timestamp the day, then the month, then the year in 3 variables. Thank you for your help :

  Read the article

• Convert PHP date into javascript date format

  - by LeeTee

  I have a PHP script that outputs an array of data. This is then transformed into JSON using the json_encode() function. My issue is I have a date within my array and its is not in the correct javascript format. How can I convert this within PHP so it is? $newticket['ThreadID'] = $addticket; $newticket['Subject'] = $subject;…

  Read the article

• How do I get the last day on the month using SQL Reporting Services

  - by Cory

  In SQL Server Reporting Services, how would I get calculate the last day of the current month?

  Read the article

• Any good lightweight date/time picker for web with good UI ?

  - by nexneo

  Few wishes, If it is jQuery based, best. If it focus easy UI then eye candy, better. If it is date and time picker both, good. Edit: I should have mentioned , I already looked most options available that I can found using google. Problem is not a single date+time picker is part of official jquery-ui project so some are for…

  Read the article

• How do I show the 'blog last updated' time in Wordpress?

  - by detj

  I want to show the time of the last blog update at the header of my wordpress blog. It's not the last update time of a post but rather any post or page (i.e. any last update done in the blog) e.g. Format: Tuesday, March 16, 2010 Last Update: 6:09 PM ET Is there any template tag to accomplish this?

  Read the article

• MySQL, Coldfusion, Selecting records that were timestamped in the last 24 hours.

  - by nobosh

  With Coldfuson & MySQL - How to update the query to check for new entries that have a timestamp that occurs in the last 24 hours? Query: <cfquery name="caller.sel_BlogEntries" datasource="#request.db#"> SELECT blogentry.dateAdded, person.personName FROM blogentry INNER JOIN person ON blogentry.personID =…

  Read the article

• Adding relative week number column to MySQl results

  - by Anthony

  I have a table with 3 columns: user, value, and date. The main query returns the values for a specific user based on a date range: SELECT date, value FROM values WHERE user = '$user' AND date BETWEEN $start AND $end What I would like is for the results to also have a column indicating the week number relative to the date…

  Read the article

• UTC and Universal Time

  - by novicedeveloper

  In C#, what is the difference between UTC and Universal Time? What are the fuctions available?

  Read the article

• Formatting time in milliseconds using boost::date_time library

  - by Ylisar

  I have a time duration in milliseconds which I ideally would like to format using the formatting functionality present in the boost::date_time library. However, after creating a boost::posix_time::time_duration I can't seem to find a way to actually apply the formatting string to it.

  Read the article

• How to: get Date, Time and Time zone from single DateTimePicker Control

  - by Vijay

  Hi All, I am developing an application in which I am trying to fetch Date, Time and Time Zone from single DateTimePicker control. Can anybody help to resolve this? Thanks in advance. EditV1: I am using .net framework 2.0. Now I am able to fetch Date and Time with Single DateTimepicker by setting its CustomFormat property…

  Read the article

• check if date is within time range using joda or standart java api

  - by EugeneP

  I have first time as string '12:00:00' and another '19:00:00' next how to check time portion of the day is within these time values?

  Read the article

• javascript date.utc problem

  - by Dave

  I'm trying to compare 2 dates using javascript. 1 at the end of the month and 1 at the beginning. I need to compare these 2 dates in seconds so I'm using the Date.UTC javascript function. Here's the code: var d = Date.UTC(2010,5,31,23,59,59); document.write(d); var d2 = Date.UTC(2010,6,1,12,20,11); document.write(d2);…

  Read the article

• "Dynamic" localized display of custom DateTimePicker format

  - by S.C. Madsen

  I have a Winform application with 2 DateTimePicker's on it, initialized as follows: private void InitializeComponent() { ... this._StartDate.Format = System.Windows.Forms.DateTimePickerFormat.Short; .... this._StartTime.CustomFormat = System.Globalization.DateTimeFormatInfo.CurrentInfo.ShortTimePattern; …

  Read the article

• Should searchable date fields in a database table always be indexed?

  - by Spencer Ruport

  If I have a field in a table of some date type and I know that I will always be searching it using comparisons like between, > or < and never = could there be a good reason not to add an index for it?

  Read the article

• help in compare validate in c#

  - by scatman

  i have 2 textboxes that i am filling with StartDate, and Endate. i want to use the compareValidator to make sure that the StartDate is less that the EndDate. i used this: <asp:CompareValidator ID="Comp" ControlToValidate="txtStartDate" ControlToCompare="txtEndDate" Operator="LessThan" Type="Date"…

  Read the article

• XSLT 1.0: Sorting by concating portions of date string

  - by dscl

  I'm trying to take XML data and sort elements by their data attribute. Unfortunately the dates come over in mm/dd/yyyy format and are not static lengths. (Jan = 1 instead of 01) So I believe the string will have to be parsed into three components and the month padded. The newly concated value…

  Read the article

• Oracle TIMESTAMP w/ timezone data type confusion

  - by JuiceBox1337

  When would you use TIMESTAMP w/ timezone as opposed to TIMESTAMP w/ local time zone? When data is stored in a column of data type TIMESTAMP w/ local tz, the data is normalized to the database time zone, and the time zone displacement is not stored as part of the column data. When users…

  Read the article

• What module(s) do I need to include to get 5.seconds to work in Ruby?

  - by DJTripleThreat

  Because apparently require 'date' doesn't include the method hours or seconds etc: undefined method `hours' for 5:Fixnum (NoMethodError) Am I missing something? Is 5.seconds only something you can do in Rails? If so, what is the require statement I need to get this to work in a ruby…

  Read the article

• Insert text depending on time of day and day of week.

  - by ploughansen

  I'm trying to piece together a php script to output different text depending on what day it is and the time of day. Example: On weekdays (mon-fri), I would like to output text according to the following periods of time (24H, server time, UTC): 00:00-08:00: "Lorem ipsum" 08:00-13:00:…

  Read the article

< Previous Page | 30 31 32 33 34 35 36 37 38 39 40 41  | Next Page >