DATETIME field

[simone]

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

[Sjoerd]

Re: DATETIME field


simone wrote:[color=blue]
> 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[/color]

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

[Krustov]

Re: DATETIME field

<comp.lang.ph p>
<Sjoerd>
<27 Jun 2006 07:47:09 -0700>
<1151419629.649 110.91550@c74g2 000cwc.googlegr oups.com>
[color=blue]
> simone wrote:[color=green]
> > 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[/color]
>
> Where do you get this datetime field from? The user? MySQL?
>[/color]

I think what they meant was they want to display it in a different way
after its been grabbed from the database .


--

https://www.emailuser.co.uk/?name=KRUSTOV

[strawberry]

Re: DATETIME field

puzzled! why would you want to do that?
simone wrote:[color=blue]
> 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[/color]

[Rik]

Re: DATETIME field

simone wrote:[color=blue]
> 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[/color]

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

Grtz,
--
Rik Wasmus

[Mel]

Re: DATETIME field

On 2006-06-28 01:29:36 +1000, "strawberry " <zac.carey@gmai l.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).

[strawberry]

Re: DATETIME field

Mel wrote:

On 2006-06-28 01:29:36 +1000, "strawberry " <zac.carey@gmai l.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

[Mel]

Re: DATETIME field

On 2006-07-12 10:28:12 +1000, "strawberry " <zac.carey@gmai l.comsaid:

Mel wrote:

>On 2006-06-28 01:29:36 +1000, "strawberry " <zac.carey@gmai l.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.