Converting Date to proper format when the Value obtained from the Db is in format 2012-07-13 00:00:00.0

Question

I know there are lot of questions on this topic . But I am not getting a proper solution to my

problem.I am retrieving Date from db , I am getting the Output as

as 2012-07-13 00:00:00.0 .

I am getting the output in the string format . I want the result of type string in the

format MM/dd/yyyy.I am doing the following

NSString *dateStr=@"2012-07-13 00:00:00.0";

NSDateFormatter *df=[NSDateFormatter new];

[df setDateFormat:@"yyyy-MM-dd"];

NSDate *res=[df dateFromString:dateStr];

But here I am getting res as nil .

I just googled your question, and see what I got, https://www.google.co.in/search?q=Converting+Date+to+MM%2Fdd%2Fyy+format&aq=f&oq=Converting+Date+to+MM%2Fdd%2Fyy+format&aqs=chrome.0.57.521j0&sourceid=chrome&ie=UTF-8 — rptwsthi, May 17 '13 at 04:46
@rptwsthi : please read the entire content of my question just before down voting it. — Raj, May 17 '13 at 04:53

Antonio MG · Answer 1 · 2013-05-16T13:13:41.573

2

You need to tell the formatter the whole format of the date, including hours, minutes...

This works:

NSString *dateStr=@"2012-07-13 00:00:00.0";

NSDateFormatter *df=[NSDateFormatter new];

[df setDateFormat:@"yyyy-MM-dd hh:mm:ss.S"];

NSDate *res=[df dateFromString:dateStr];

[df setDateFormat:@"MM/dd/yyyy"];

NSString *myString =[df stringFromDate:res];

edited May 16 '13 at 13:13

answered May 16 '13 at 12:45

Antonio MG

20,382
3
43
62

NoW i Want the Output of type as string in the Format MM/dd/yy. In order to get it Should I write another dateformatter ? – Raj May 16 '13 at 12:54
Just change the format on it, check my code now – Antonio MG May 16 '13 at 12:54
After getting res I am doing NSDateFormatter *df2=[NSDateFormatter new]; [df2 setDateFormat:@"MM/dd/yy"]; NSString *finalVal=[df2 stringFromDate:res]; .Is this correct ? – Raj May 16 '13 at 12:55
@Dharmbir Choudhary: But sometimes When the output from the db is 2013-05-16 16:29:52.072, I am again gtting nil. – Raj May 16 '13 at 13:19
@Raj in this case you need to change format for this type of string. And first make sure what kind of string string format will you get . – Dharmbir Singh May 16 '13 at 13:20
Yea ..Can u please tell me the format – Raj May 16 '13 at 13:21
Then use: :@"yyyy-MM-dd hh:mm:ss.SSS" – Antonio MG May 16 '13 at 13:22
@Antonio MG: This format yyyy-MM-dd hh:mm:ss.SSS gives nil again – Raj May 16 '13 at 13:26
@Antonio MG:Sorry I meant to say this format yyyy-MM-dd hh:mm:ss.SSS gives nil again . – Raj May 16 '13 at 13:30
@Raj [dateFormatter setDateFormat:@"yyyy-MM-dd HH:mm:ss.SSS"]; This will work fine. Try to use this one.. – Dharmbir Singh May 16 '13 at 13:33

Vaibhav Saran · Answer 2 · 2013-05-16T12:54:01.127

0

try this:

NSDateFormatter *formatter = [[NSDateFormatter alloc] init];
[formatter setDateFormat:@"yyyy-MM-dd HH:mm:ss.s"];
NSDate *aDate=[formatter dateFromString:[NSString stringWithFormat:@"%@", @"2012-07-13 00:00:00.0"]];

NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
[dateFormatter setDateStyle:NSDateFormatterShortStyle];
[dateFormatter setTimeStyle:NSDateFormatterNoStyle];
NSLog(@"%@", [dateFormatter stringFromDate:aDate]);

edited May 16 '13 at 12:54

answered May 16 '13 at 12:47

Vaibhav Saran

12,848
3
65
75

if working, then you should checkmark any of these working answers! – Vaibhav Saran May 17 '13 at 05:19

Dharmbir Singh · Accepted Answer · 2013-05-17T05:03:05.833

0

Use this one

 NSString *dateStr=@"2012-07-13 00:00:00.0";
 NSDateFormatter *df = [[NSDateFormatter alloc] init];
 [df setDateFormat:@"yyyy-MM-dd HH:mm:ss.S"];  

  NSDate *date = [df dateFromString: dateStr]; 

  [df setDateFormat:@"MM/dd/yyyy"];

  NSString *convertedString = [df stringFromDate:date]; 
  NSLog(@"Your String : %@",convertedString);

Output: Your String : 07/13/2012

edited May 17 '13 at 05:03

answered May 16 '13 at 12:52

Dharmbir Singh

17,485
5
50
66

@Raj You know my dear value of Date String is @"2012-07-13 00:00:00.0". So it will give this output.Do you understand? – Dharmbir Singh May 16 '13 at 13:08
But sometimes When the output from the db is 2013-05-16 16:29:52.072 I am again getting nil. – Raj May 16 '13 at 13:21
@Raj see this format [dateFormatter setDateFormat:@"yyyy-MM-dd HH:mm:ss.SSS"]; this will work fine. – Dharmbir Singh May 16 '13 at 13:32
yea that works perfectly fine . I was using "yyyy-MM-dd hh:mm:ss.SSS , hence it was giving nil , in my case – Raj May 17 '13 at 04:59
please change hh in your answer to HH . I will accept it – Raj May 17 '13 at 04:59

score 0 · Answer 4 · answered May 16 '13 at 13:11

Try this

    NSString *dateStr=@"2012-07-13 00:00:00.0";
    NSDateFormatter *dateFormatter=[NSDateFormatter new];
    [dateFormatter setDateFormat:@"yyyy-MM-dd hh:mm:ss.S"];
    NSDate *dateObj=[dateFormatter dateFromString:dateStr];
    [dateFormatter setDateFormat:@"MM/dd/yyyy"];
    NSString *myString = [dateFormatter stringFromDate:dateObj];
    NSLog(@"%@",myString);

Converting Date to proper format when the Value obtained from the Db is in format 2012-07-13 00:00:00.0

4 Answers4