date

Different value of date display between database and data table

I have a problem with display of dates from Oracle database in a Java webapplication using a JSF datatable. The displayed date differs from the date in the database. Here are some examples: in oracle: 24-APR-87 display in datatable: Apr 23, 1987 in oracle: 01-JAN-10 display in datatable: Dec 31, 2009 in oracle: 13-MAR-89 display in...

Convert epoch to date in sqlplus / Oracle

Hi, I have the following table: SQL> desc recording Name Null? Type -------------------- -------- ------ CAPTUREID NOT NULL NUMBER(9) STARTDATE NOT NULL DATE ENDDATE DATE STATE NUMBER(1) ESTIMATEDENDTIME NUMBER(13) Here's a sing...

How can I make dbUnit or hibernate stop subtracting an hour from my dates?

So, I have an XML file I am using with dbUnit as a data source, and it has some dates in it. The date in the file is like so: "2010-02-04", but once it gets loaded and I access it to print or compare in tests, it thinks the date is "2010-02-03 23:00". I'm guessing this has to do with EDT/EST, but I'm not sure how I can force dbUnit (or...

What is wrong with my date regex?

var dateRegex = /\/Date\((\d+)\)\//g; // [0-9] instead of \d does not help. dateRegex.test("/Date(1286443710000)/"); // true dateRegex.test("/Date(1286445750000)/"); // false Both Chrome and Firefox JavaScript consoles confirm. What the hell, guys? Edit: even simpler test case: var dateRegex = /Date\(([0-9]+)\)/g; dateRegex.test("...

Using drupal profile date in vb.net

I am using drupal databas ein one of my application. Drupal profile saves date in following format: a:3:{s:5:"month";s:1:"2";s:3:"day";s:2:"18";s:4:"year";s:4:"1995";} I can read this with data reader but how to convert in a proper display like DD/MM/YYYY or YYYY/MM/DD ...

Ruby strftime: Month without leading zero?

Does Ruby's strftime have a format for the month without a leading zero? I found %e for getting the day without the leading zero, but not having any luck with the month. Ultimately wanting a date formatted like: 9/1/2010 ...

best way to convert date from javscript string in format YYYYMMDD to javascript date

What is best way to convert date from javscript string in format YYYYMMDD to javascript date format. var from_date = document.getElementById('from_date').value; var YYYY = from_date.substring(0,4); var MM = from_date.substring(4,7); var DD = from_date.substring(7,8); ...

Pick up date, add day and put back

I want to pick up date from screen, add 1 day and put back to screen. <input type='text'value='20101231' id='from_date'> <script> function date_move(direction){ var from_date = document.getElementById('from_date').value; var YYYY = from_date.substring(0,4); var MM = from_d...

Preg_match for a date

Hello everyone, I am trying to match a date in PHP using preg_match, split it and assign parts of it to an array, the date looks like "20100930", here is the code I am using: // Make the tor_from date look nicer $nice_from = $_POST['tor_from']; $matches = array(); $ideal_from = ''; preg_match('/\d{4}\\d{2}\\d{2}\/', $nice_from, $matc...

Objective C / iPhone: How do I extract the actual unicode date format strings for the current region?

I am completely new to objective c and iphone development, so please be gentle (just started looking at the code for the first time tonight). According to this site: http://iphonedevelopertips.com/cocoa/date-formatter-examples.html there is a class that handles formatting, which takes in a set of constants/enums (e.g. NSDateFormatterSh...

How do I programmatically (C++) check the code signing date of an EXE in Windows?

Is this possible? How do I go about doing it? Does it require admin rights? (I would not think so) A pointer to a help page or link is fine - no need to provide code. Given my difficulty with he code signing cert and setting it up in our build environment I am not sure I am googling with the right terms. EDIT After some searchin...

Is Friday with date format "c" returned as 5 or 6 ?

Initially I thought that using this code + (NSString *)getDayOfTheWeek:(NSDate *)date format:(NSString*)format { NSDateFormatter *dateFormatter = [[[NSDateFormatter alloc] init] autorelease]; dateFormatter.dateFormat = format; NSString *formattedDateString = [dateFormatter stringFromDate:date]; NSLog(@"Des pico je: %@",formattedD...

Android/Java - Date Difference in days

Hello i am getting the current date (in format 12/31/1999 i.e. mm/dd/yyyy) as using the below code: Textview txtViewData; txtViewDate.setText("Today is " + android.text.format.DateFormat.getDateFormat(this).format(new Date())); and i am having another date in format as: 2010-08-25 (i.e. yyyy/mm/dd) , so i want to find the di...

Formatting a date

Edit: Updating post based on Martins comments below Hello, I'm just trying to get a date from a string, my code is as follows: NSString *strStartDateTime = [startTimeArray objectAtIndex:i]; NSDateFormatter *formatter = [[NSDateFormatter alloc] init]; [formatter setDateFormat:@"yyyy-MM-dd HH:mm:ss"]; NSDate *dtStartDateT...

convert date from "2009-12 Dec" format to "31-DEC-2009"

'2009-12 Dec' should be converted to '31-DEC-2009' '2010-09 Sep' should be converted to '30-SEP-2010' '2010-02 Feb' should be converted to '28-FEB-2010' '2008-02 Feb' should be converted to '29-FEB-2008' The values 2009-12 Dec, 2008-02 Feb will be displayed to the User in a drop down. The User have no option to select the DAY. The use...

Add a Specific Time to a Date Value

I have a stored procedure that receives a date value like this: @AsOf date In the query I am using this date to filter a datetime field. I need to convert the date passed in to a datetime field with the time portion set to 09:00:00 PM so I can add a filter in the WHERE clause like this: (DateCreated < @TimeAsOfNinePM) I know this i...

How can I get the today's date?

In my Blackberry application I'd like to get today's date so I can display it in a textbox. Similar to C#'s DateTime.Now. I'm using two EditFields to act as a filter so a user can say show me records between today and 7 days ago. So I need: Show today's date as default. Show the date 7 days prior to today. Thanks a bunch for the h...

Figure out type of timestamp

Hi, I've occured a strange time-format, and i can't figure out how to convert it to a readable format. A couple of timestamps from today are 32400683 (this morning) 41891077 56517540 57390993 58728120 (this afternoon) ...

PHP Date/Time and mktime

Hopefully someone can tell me whats going on with this little debugging script. <?PHP // function generates the list of times for function generateTimes($date) { $currentDate = $date; echo "RECEIVED CURRENT DATE: " . date("m/d/Y g:iA", $currentDate) . "<br /><br />"; for($i = 0; $i < 48; $i++) { echo date("g:iA", $currentDat...

Flex DateTimeAxis: Displaying dates in another timezone (neither local nor UTC)

Hi, I'm working with an AreaSeries + DateTimeAxis in Flex 4. The dates for the time axis originate from a server in another time zone. I'd like to see the graph (in my local time zone) displayed using the server's time zone. I know that I can set the DateTimeAxis.displayLocalTime property to true or false, to have dates displayed in the...