By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,985 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,985 IT Pros & Developers. It's quick & easy.

DATETIME field

P: n/a
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration

Simone

Jun 27 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a

simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration


Where do you get this datetime field from? The user? MySQL?

Jun 27 '06 #2

P: n/a
<comp.lang.php>
<Sjoerd>
<27 Jun 2006 07:47:09 -0700>
<11*********************@c74g2000cwc.googlegroups. com>
simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration


Where do you get this datetime field from? The user? MySQL?


I think what they meant was they want to display it in a different way
after its been grabbed from the database .
--
www.emailuser.co.uk/?name=KRUSTOV
Jun 27 '06 #3

P: n/a
puzzled! why would you want to do that?
simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration

Simone


Jun 27 '06 #4

P: n/a
Rik
simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration


strftime('%d-%m-%y%C',strtotime($field));

Grtz,
--
Rik Wasmus
Jun 27 '06 #5

P: n/a
Mel
On 2006-06-28 01:29:36 +1000, "strawberry" <za*******@gmail.comsaid:
puzzled! why would you want to do that?
simone wrote:
>hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration

Simone

Becuase DD-MM-YYYY is the standard date format for most countries.

^-- that's my Best Guess(TM).

Jul 11 '06 #6

P: n/a
Mel wrote:
On 2006-06-28 01:29:36 +1000, "strawberry" <za*******@gmail.comsaid:
puzzled! why would you want to do that?
simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration

Simone


Becuase DD-MM-YYYY is the standard date format for most countries.

^-- that's my Best Guess(TM).
yeah, but the op wants dd-mm-yycc

Jul 12 '06 #7

P: n/a
Mel
On 2006-07-12 10:28:12 +1000, "strawberry" <za*******@gmail.comsaid:
Mel wrote:
>On 2006-06-28 01:29:36 +1000, "strawberry" <za*******@gmail.comsaid:
>>puzzled! why would you want to do that?
simone wrote:
hi,
I have a datetime field with this format 'CCYY-MM-DD
hh:mm:ss'. I'd like to display as a 'DD-MM-YYCC'.
thanx for your collaboration

Simone


Becuase DD-MM-YYYY is the standard date format for most countries.

^-- that's my Best Guess(TM).

yeah, but the op wants dd-mm-yycc
Oh. Right you are. That's really odd.

Jul 12 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.