Search Results

Search found 12421 results on 497 pages for 'date arithmetic'.

Page 52/497 | < Previous Page | 48 49 50 51 52 53 54 55 56 57 58 59  | Next Page >

• cant get ordering mysql results by current date ASC to work

  - by Patrick

  Im trying to order results ASCENDING from the current date this is what im using now; SELECT * FROM friends JOIN bdays ON bdays.user = friends.friendname WHERE username = $userid ORDER BY DATE_FORMAT(date, '%m %d') any ideas?

  Read the article

• How to get the users set of date format pattern strings? (3 replies)

  I would like to get the current user's set of date format pattern strings as listed in the Control Panel regional settings applet. For my UK English system I see the following patterns listed: Short Date: dd/MM/yyyy dd/MM/yy d/M/yy d.M.yy yyyy MM dd Long Date: dd MMMM yyyy d MMMM yyyy If I use GetDateTimeFormats (d and D) the results match the expected patterns above, but of course they're the for...

  Read the article

• Date range intersection in SQL

  - by Will

  I have a table where each row has a start and stop date-time. These can be arbitrarily short or long spans. I want to query the sum duration of the intersection of all rows with two start and stop date-times. How can you do this in MySQL? Or do you have to select the rows that intersect the query start and stop times, then calculate the actual overlap of each row and sum it client-side?

  Read the article

• Get remote PC's date time?

  - by David.Chu.ca

  Is there any class available to get a remote PC's date time in .net? In order to do it, I can use a computer name or time zone. For each case, are there different ways to get the current date time? I am using Visual Studio 2005.

  Read the article

• what is the difference between <pubDate> and <dc:date> in feed's structure

  - by PHP-Prabhu

  can any one please let me know the main difference between <pubDate> and <dc:date> in feed's structure. also please explain <dc:date> <dc:creator> <dc:....> <dc:....> will those be required for building feeds?

  Read the article

• DOS Batch file to find "new" files by date

  - by Todd McArthur

  My PC has entered an infinite BSOD loop - but I do have access to a safe-mode command prompt. I'm trying to get an idea of "what changed" that might have triggered this. e.g. I might have gotten a virus, or an app update went belly up. I'd like to thus see which files were created/modified in the last few days/week or at least the *.exe, *.dll, *.com, *.bat etc. I thought I was ok with my Batch-fu but I'm stumped on how to write a quick batch file/command that would list the files for me. REM This will find the files, but the results are all muddled REM all EXE files, reverse sort by date, recursively through sub-directories dir *.exe /O-D /S What I'd really like is to find all (executable filetypes) that were created/modified in the last 3-7 days. Can anyone point me in the right direction?

  Read the article

• DateTimePicker: pick both date and time

  - by Grzenio

  Is it possible to use DateTimePicker (Winforms) to pick both date and time (in the dropdown)? How do you change the custom display of the picked value? Also, is it possible to enable the user to type the date/time manually?

  Read the article

• How to index a date column with null values?

  - by Heinz Z.

  How should I index a date column when some rows has null values? We have to select rows between a date range and rows with null dates. We use Oracle 9.2 and higher. Options I found Using a bitmap index on the date column Using an index on date column and an index on a state field which value is 1 when the date is null Using an index on date column and an other granted not null column My thoughts to the options are: to 1: the table have to many different values to use an bitmap index to 2: I have to add an field only for this purpose and to change the query when I want to retrieve the null date rows to 3: locks tricky to add an field to an index which is not really needed What is the best practice for this case? Thanks in advance Some infos I have read: Oracle Date Index When does Oracle index null column values?

  Read the article

• Localized Date Validator

  - by Blithe

  Is there a way to use user's culture to localize the Range Validator for date? I am looking for a good way to validate date and avoiding to provide a fix format (e.g.: do a dd/mm/yyyy using Regular Expression Validator)

  Read the article

• Find a date between start_date and end_date

  - by Margaret

  I have a table of events with a recorded start and end time. I want to find all events that occur on a specific date. Some events started a year ago and some will continue farther ahead. I would like to be able to pick for example May 20, 2010 and find all events occurring on that date.

  Read the article

• Rename multiple files as "Modified Date/Time" using cmd or Powershell

  - by Mehper C. Palavuzlar

  I have hundreds of JPG files in a folder. I want to rename each file so that the file name is replaced with "Modified Date/Time" of that file, namely DD.MM.RRRR.HH.MM.jpg. For example, Before After 001.jpg 11.01.2011.16.58.jpg 002.jpg 12.01.2011.09.32.jpg 003.jpg 14.01.2011.12.41.jpg ... ... Since colon (:) cannot be used in file names, the colon between HH and MM must be replaced with a period. I don't want to use a 3rd party tool. Can you provide me with the code to achieve this in Powershell or command line?

  Read the article

• how to enter manual time stamp in get date ()

  - by Arunachalam

  how to enter manual time stamp in get date () ? select conver(varchar(10),getdate(),120) returns 2010-06-07 now i want to enter my own time stamp in this like 2010-06-07 10.00.00.000 i m using this in select * from sample table where time_stamp ='2010-06-07 10.00.00.000' since i m trying to automate this query i need the current date but i need different time stamp can it be done .

  Read the article

• Date format broken in .net 4.0 for uk format

  - by Chris Foot

  I'm in the process of converting a couple of sites up to .net 4.0 and I seem to have a problem with regionalisaion of dates. This code: Date.Today.AddDays((Date.Today.DayOfWeek - 1) * -1).ToString() In .net 3.5 produces: '19/04/2010 00:00:00' but as soon as I change the app pool to 4.0 it produces: '4/19/2010 12:00:00 AM' Where can I change the setting that governs this?

  Read the article

• SQL dynamic date but fixed time query

  - by Marko Lombardi

  I am trying to write a sql query like the example below, however, I need it to always choose the DateEntered field between the current day's date at 8:00am and the current day's date at 4:00pm. Not sure how to go about this. Can someone please help? SELECT OrderNumber , OrderRelease , HeatNumber , HeatSuffix , Operation , COUNT(Operation) AS [Pieces Out of Tolerance] FROM Alerts WHERE (Mill = 3) AND (DateEntered BETWEEN GetDate '08:00' AND GetDate '16:00') GROUP BY OrderNumber, OrderRelease, HeatNumber, HeatSuffix, Operation

  Read the article

• Date validation in PHP

  - by Rachel

  What would the regex expression that would go into preg_split function to validate date in the format of 7-Mar-10 or how can I validate a date of format 7-Mar-10 in PHP Thanks.

  Read the article

• Java ME get yesterday's date

  - by Nimrod Shory

  Hello, I need to get yesterday's date from a Java ME midlet. I know Java's Calendar object has an add method but Java ME's Calendar doesn't have it. Is there an easy way to retrive yesterday's date? Thanks.

  Read the article

• CompareValidator date format

  - by ashtame

  Hi, I have an ajax calendar control that I specified the date format to be yyyy-MM-dd. Is it possible to have the comparevalidator validate that type of date sepcifically and have it fail for everything else? right now it seems to only take dd-MM-yyyy. Thanks.

  Read the article

• Date based sum in Excel / Google Docs spreadsheets

  - by alumb

  I have a bunch of rows with a date and a dollar amount (expenses). I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the list would be 8/5/2008 and the sum of all the expenses that occurred on or before 8/5/2008. Approximately this is =sumif(D4:D30-A5,">0",E4:E30) but of course that doesn't work (where the source data is dates in D4:D30 and the expenses are in E4:E30). Notes source data can't be sorted for various reasons. must work in google spreadsheets, which is a fairly complete subset of excel's functions.

  Read the article

• Struts 1 Date Format Tag

  - by David

  Is there any tag in the Struts 1 tag library which can format a java.util.Date object? In Struts 2, I can use the s:date tag, but I can't find the Struts 1 equivalent.

  Read the article

• How to log the installation date to the registry

  - by MX4399

  When an install completes successfully, the date and time and some other info needs to be written to the registry. How can a date be generated and how do you know if an install was completed successfully? (writing to the registry with wix is not a problem).

  Read the article

• Mysql - datetime and date-range comparsion

  - by Ockonal

  Hello guys, I have datetime-row in mysql database. I have to check time between now and that date using php. If the range is bigger then 1 month - do somtething. I tried something like this: $dateFromMysql = strtotime($rowData); $currentDate = date("m/d/y g:i A"); And then comparsion by hands. It's ugly.

  Read the article

• How to format the date into words

  - by Kalpana

  I am trying to convert java.util.Date into string as "Twenty Sixth of October Nineteen Ninety Three" for the date 26-10-1993. How to do this in a generic fashion?

  Read the article

• how to get date from week and day of the week in oracle

  - by Deven

  i am having week number and day of that week then how can i get date example week number=20 and day of that 20th week is friday then ? what is date?

  Read the article

• RSS feed publish date-time(GMT) to unix timestamp format using php

  - by PHP-Prabhu

  can anyone reply me, How do convert RSS feed publish date-time(GMT) to UNIX time-stamp using php. I need to store the date into my table with the field'd data type as TIMESTAMP.

  Read the article

• How to keep track of the change in date in JAVA

  - by JavaGeek

  I have an application that needs to do some actions every date change say at midnight. Whenever the date changes the application should be said of the same. Any help regarding how to implement the functionality would be appreciated. Thanks in advance.

  Read the article

< Previous Page | 48 49 50 51 52 53 54 55 56 57 58 59  | Next Page >