FAQ Database Discussion Community


JSON-Data Date_Format doesnt show

javascript,mysql,json,date,date-format
Hello and sorry my bad english :-) i have a little problem with my json data. I have a mysql database. in this database i have safed data in a date format. But the date format is in this format: YYYY.MM.DD. I need the Format DD.MM.YYYY. Well, i changed the...

How can I correctly parse this kind of date?

java,date,date-format,simpledateformat
I could not find a correctly and clean working solution for my Date which is formatted like this: 201406082159 (8th of June, 21:59 here) Last I tried was this: SimpleDateFormat format2 = new SimpleDateFormat("YYYYMMDDHHMM", Locale.ENGLISH); Sadly it's not working and printing out Sun Dec 29 21:00:00 CET 2013 ...

migx TV (MODx REVO) - date format

date,date-format,modx,modx-revolution
I have a problem I can not bring a date without time through MIGX TV Created by TV type migx {«Field»: «Date», «caption»: «Date», «inputTVtype»: «date»} I deduce this way [[+ date]] everything appears normal, but is displayed as the date and time and I want to display only the...

what's this date format ? 2006-09-01T07:00:00.000+0000 ? is it ISO_8601 ?

date-format,momentjs,iso8601
I am working on REST calls where I need to send date in "2006-09-01T07:00:00.000+0000" format. User enters date in "YYYY/MM/DD" format and I am using "moment.js" to format the date in ISO 8601 using this format "YYYY-MM-DDTHH:MM:SS.MMMZ" . But it gives me this output "1969-06-20T00:06:00.Jun-07:00". So, how do I get...

iOs - error with NSDateFormatter

ios,nsdate,date-format
I have a Date with value 2015-05-31 22:00:00 UTC (I parse it from a NSString with value "01-06-2015" and it give that value) and when I parse it it become 01-06 why?? I need to get on nextdate the value = 2015-06-1 22:00:00 UTC because I need to get the...

Changing the date format from mm/dd/yyyy [duplicate]

java,date-format,simpledateformat
This question already has an answer here: How can I change the date format in Java? 7 answers I need to change the date format from 2015-04-08 to 08-APR-2015. It is coming from grails gsp front end. Before calling oracle package I need to change the format in java....

Is there a way to format Date in the format explained below

java,date-format,simpledateformat,java.util.date
I have a Date object created by new Date(); When I do String.valueOf(new Date()) I get "Mon Jan 10 11:11:11 PST 2015" Is there a way to format in the following way: Monday Jan 10, 2015 at 5:15 PM I tried DateFormat and all its examples but not able to...

Bootstrap date-time picker asp.NET MVC

jquery,css,asp.net-mvc,date-format,datetimepicker
I am using this function <script src="~/Scripts/jquery.datetimepicker.js"></script> <script type="text/javascript"> $(function () { $('.datetimepicker').datetimepicker({}); }); </script> And this code to show the datetime: @Html.EditorFor(model => model.SomeNameDateTimeFormat, new { htmlAttributes = new { @class = "form-control input-sm datetimepicker"} }) However, css is not working at all, it renders calendar on the side...

Trying to convert certain formats into a date format

excel,vba,date-format
I have been able to get the code below to successfully convert general values "19082015" and "9052015" into the date format dd/mm/yyyy. But when I try converting the general value "19.08.2015" in the same code, it does not run the macro and shows: Run time error '13': Type mis-match On...

How can I correctly parse this specific Date [duplicate]

java,date,date-format,simpledateformat
This question already has an answer here: Converting ISO 8601-compliant String to java.util.Date 19 answers Please don't downvote me into oblivion, but I could not find a correctly and clean working solution for my Date which is formatted like this: 2014-06-09T00:01+0200 (9th of June here) Last I tried was...

SimpleDateFormat for a HTTP Date

java,datetime,date-format,simpledateformat
I can parse a HTTP Date but I don't get what I want, i.e. in this Example import java.text.SimpleDateFormat; import java.util.Date; import java.util.Locale; import java.util.TimeZone; public class Example01 { public static void main(String[] argv) throws Exception { Date date = null; String dateValue = "Tue, 27 Jan 2015 07:33:54 GMT";...

ASP.NET MVC5 stores date in wrong format

asp.net,asp.net-mvc-5,jquery-ui-datepicker,date-format,datefield
last days I have a quite hard time to convince MVC5 project to work with dates as I would like to. After intensive googling I've tried numerous attepmts to make it work properly, but without success. Here is the problem: I need to display and edit dates on my webpage...

Date Format not accepted in SQl

java,mysql,date,datetime,date-format
I have Query Like this Query: SELECT * FROM attendance_entry WHERE absent_date="Fri Feb 20 00:00:00 IST 2015"; In Mysql absent_date is in these format(yyyy-mm-dd). When I am using Hiberante Criteria it accepts. How to write Query?...

NSDateFormatter- stringFromDate not returning AM/PM

ios,datetime,nsdate,nsdateformatter,date-format
NSDateFormatter *formatter = [[NSDateFormatter alloc] init]; [formatter setDateFormat:@"hh:mm:ss a"]; NSLog(@"Today's Time: %@", [formatter stringFromDate:[NSDate date]]); The above code just gives the following output Today's Time: 15:46:43 I want the output to be Today's Time: 3:46 PM. I surfed a lot and i did not find a way to show...

java format particular date with T character

java,date,date-format,simpledateformat
What is the correct form for parse this date?: 2015-05-29T00:00:00+02:00 DateFormat format = new SimpleDateFormat("yyyyy-mm-dd hh:mm:ss"); Date data = format.parse(dataValue); ...

How to compare timestamps in MySql table and select older than given time period [closed]

mysql,date,timestamp,date-format
Timestamps and date formats were allways puzzling me a little bit. Let's say we have a MySql table where date column is in timestamp format. I'd like to ask what is the easiest or simplest way how to find all table rows older than, for example 1 week....

show only weekday from date

asp.net,vb.net,date-format
I'm trying to use a date value I have in my table to show the start date of a holiday as the day value (Monday, Tuesday etc) how would be the best way to go about getting the start day value in this format in VB.NET? I'm currently working with...

issue in display Date in different format with one string value android

java,android,date,date-format,simpledateformat
Hello friends i have one string value for date like "2015-02-04" and below is my code Date todaysDate = new java.util.Date("2015-02-07"); SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy"); SimpleDateFormat df2 = new SimpleDateFormat("dd-MM-yyyy HH:mm:ss"); SimpleDateFormat df3 = new SimpleDateFormat("dd-MMM-yyyy"); SimpleDateFormat df4 = new SimpleDateFormat("MM dd, yyyy"); SimpleDateFormat df5 = new SimpleDateFormat("E, MMM...

How to compare two date in querybuilder

php,symfony2,doctrine2,date-format
I'm trying to create a search form and I need to compare selected date with the others dates in database. The selected date has this format (dd/mm/yyyy) and the dates saved in database have this format (mm-dd-yyy) $qb = $this->createQueryBuilder('t') ->leftJoin('t.image', 'i')->addSelect('i') ->leftJoin('t.country', 'country')->addSelect('country') ->leftJoin('t.destination', 'destination')->addSelect('destination') ->leftJoin('t.airport', 'airport')->addSelect('airport') ->Where('t.agence =...

Changing date format using FORMAT

mysql,sql,date,date-format
I've got dates in my database stored as varchars in the format: dd/mm/yyyy e.g. 1/3/2015 I'm trying to change the format to yyyy/mm/dd so I can convert them into timestamps. When I try this: SELECT FORMAT (date, 'dd/mm/yyyy', 'yyyy/mm/dd' ) AS t FROM tracker; It returns only one number per...

How to get Date in the same format as String

java,date,date-format
I want to get the Date object which contains Date in the form yyyy-mm-dd after adding few months to existing Date object. Using DateFormat object I have tried this way but its not giving the output as I want. How can I get this Date format in Java? My code-...

MySQL: STR_TO_DATE with YYWW

mysql,date,date-format,str-to-date
How do you use MySQL with YYWW instead of YYYYWW? My field looks like this: wYYWW, for example w1310, w1506 and so on. %x and %X seems to need 4 digits, and therefor it doesn't work. Is there anyway to solve this problem?...

How to correctly create a date with a specific format? [duplicate]

java,date,date-format
This question already has an answer here: Java date/time format 6 answers I have the following doubt related how to create a format date in Java. In a Java application I have to create a date (the value have to be the current date) formatted in this way: 2015-05-26...

Check if a string contains only date

java,date,date-format
I have a string which can contain a date(yyyy-MM-dd) or date and time (yyyy-MM-dd HH:mm:ss) in respective formats. I want to know which strings contains only date. DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); System.out.println(dateFormat.parse("2015-02-02")); System.out.println(dateFormat.parse("2015-02-02 23:23:23")); In above code, both the strings are parsed successfully, whereas the format is same for...

MySQL query not pulling up records for next year

mysql,sql,select,date-format
I have a basic query that will pull records from two tables, and the criteria is that the date is equal to, or greater than today. It will fetch everything for this year only. It looks like this: ds_postmeta.meta_value >=Date_Format(CURDATE(), ('%m/%d/%Y')) Any ideas? I have never seen this before...

In android, Is it possible to format a date object to mm-dd-yy? If yes, then how? [duplicate]

java,android,date,date-format,simpledateformat
This question already has an answer here: How do you format date and time in Android? 15 answers I have to display the date in dd-mm-yy format as per the UI design for our Android app. can any one help me, how to achieve it?...

Changing date format in datagridview

c#,excel,datagridview,date-format
I have an excel file which contain two columns of dates, the format of the date is mm/dd/yyyy . Now I am exporting it to my DataGridView and save it to my database. But after saving it, the format of the dates are changed, it is mm/dd/yy hh:mm:ss. How would...

Java Date Format in “args”

java,date-format,simpledateformat,args
So, I'm using JD-GUI to decompile some Java class files which doesn't have any documentation. This Java Application is running on a Windows Server and running via taskscheduler with a cmd file (I don't know exactly what, intern here). If some one who worked with an args command can help...