Splitting date into chunks

[Jason Carlton]

I'm sure this is an easy one, but I can't seem to find it! I have the
date and time as:

# Nov 28, 2007, 11:11:14pm
$timestamp = 20071128231114;

In Perl, I would split this up as:

my ($year, $month, $day, $hr, $min, $sec) = $timestamp =~ /(\d{4})(\d
\d)(\d\d)(\d\d) (\d\d)(\d\d)/;

How do I do the same thing in PHP? I know that I can use substr, of
course, but there has to be a better way that I'm overlooking.

TIA,

Jason

[velhari]

On Nov 29, 9:13 am, Jason Carlton <jwcarl...@gmai l.comwrote:

I'm sure this is an easy one, but I can't seem to find it! I have the
date and time as:

# Nov 28, 2007, 11:11:14pm
$timestamp = 20071128231114;

In Perl, I would split this up as:

my ($year, $month, $day, $hr, $min, $sec) = $timestamp =~ /(\d{4})(\d
\d)(\d\d)(\d\d) (\d\d)(\d\d)/;

How do I do the same thing in PHP? I know that I can use substr, of
course, but there has to be a better way that I'm overlooking.

TIA,

Jason

Jason,

list($year, $month, $date, $hour, $minute, $second) = split("
",date("Y m d H i s",timestamp ));
Hope it helps.

Thanks,
Velhari

[Jason Carlton]

list($year, $month, $date, $hour, $minute, $second) = split("

",date("Y m d H i s",timestamp ));
Hope it helps.

That's very cool, but it's not working quite right. I've tried several
variations, and keep getting the wrong thing.

If I type in:

$timestamp = 20050714010317;
echo date('Y m d H i s', $timestamp);

Then it returns:

2038 01 18 22 13 44

Any idea where that's coming from?

[John Dunlop]

Jason Carlton:

I'm sure this is an easy one, but I can't seem to find it! I have the
date and time as:

# Nov 28, 2007, 11:11:14pm
$timestamp = 20071128231114;

In Perl, I would split this up as:

my ($year, $month, $day, $hr, $min, $sec) = $timestamp =~ /(\d{4})(\d
\d)(\d\d)(\d\d) (\d\d)(\d\d)/;

The preg_* functions take Perl-compatible regular expressions.

http://www.php.net/manual/en/ref.pcre.php

--
Jock

[taps128]

Jason Carlton wrote:

I'm sure this is an easy one, but I can't seem to find it! I have the
date and time as:

# Nov 28, 2007, 11:11:14pm
$timestamp = 20071128231114;

In Perl, I would split this up as:

my ($year, $month, $day, $hr, $min, $sec) = $timestamp =~ /(\d{4})(\d
\d)(\d\d)(\d\d) (\d\d)(\d\d)/;

How do I do the same thing in PHP? I know that I can use substr, of
course, but there has to be a better way that I'm overlooking.

TIA,

Jason

I think you don't have a timestamp in the true sense, I think your
$timestamp variables shows an unformated date '2007-11-28 23:11:14'.

Which is what you looked for in your regular expression in perl, i think.
In php you can use:
$year=substr($t imestamp,0,4);
$month=substr($ timestamp,4,2);
$day=substr($ti mestamp,6,2);
$hour=substr($t imestamp,8,2);
$minute=substr( $timestamp,10,2 );
$second=substr( $timestamp,12,2 );

I think that will solve your problem.

[Jason Carlton]

I think you don't have a timestamp in the true sense, I think your

$timestamp variables shows an unformated date '2007-11-28 23:11:14'.

Which is what you looked for in your regular expression in perl, i think.

<snip>

I guess it's usually called a "datetime" instead of a "timestamp" . I
didn't know that until I started researching it tonight, though.

You're correct, the format I have doesn't have any delimiters, it's
just a series of 14 numbers. I have been using substr, like you
suggested, but since the format I used in Perl was a lot faster than
the Perl version of substr, I was hoping that there might be a faster
option in PHP, too.

Using substr seems to be pretty fast at the moment, though, so maybe
it's not too bad. PHP seems to process a bit faster than Perl did,
probably because it doesn't need the external DBI module.

- Jason

[Jason Carlton]

The preg_* functions take Perl-compatible regular expressions.

>
http://www.php.net/manual/en/ref.pcre.php

--
Jock

Jock, I did NOT realize this! Wow, you've just opened up a whole new
world for me. I've been programming in Perl for about 12 years and
only recently started using PHP, so these expressions are going to
make a world of difference.

Just curious, are these expressions slower than innate PHP
expressions? The whole reason I started using PHP in the first place
was for a little extra speed while utilizing databases.

- Jason

[Toby A Inkster]

velhari wrote:

list($year, $month, $date, $hour, $minute, $second) = split(" ",date("Y
m d H i s",timestamp ));

Argh no! Take a look at his timestamp -- it's not a Unix timestamp, but an
ISO date with the punctuation removed.

Try:

preg_match('/(\d{4})(\d\d)(\ d\d)(\d\d)(\d\d )(\d\d)/', $timestamp, $m);
list($dummy, $year, $month, $date, $hour, $minute, $second) = $m;
unset($dummy, $m);

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 4 days, 16:18.]
[Now Playing: Semisonic - Sunshine and Chocolate]

Sharing Music with Apple iTunes
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/

[taps128]

Jason Carlton wrote:

>I think you don't have a timestamp in the true sense, I think your
$timestamp variables shows an unformated date '2007-11-28 23:11:14'.

Which is what you looked for in your regular expression in perl, i think.

<snip>

I guess it's usually called a "datetime" instead of a "timestamp" . I
didn't know that until I started researching it tonight, though.

You're correct, the format I have doesn't have any delimiters, it's
just a series of 14 numbers. I have been using substr, like you
suggested, but since the format I used in Perl was a lot faster than
the Perl version of substr, I was hoping that there might be a faster
option in PHP, too.

Using substr seems to be pretty fast at the moment, though, so maybe
it's not too bad. PHP seems to process a bit faster than Perl did,
probably because it doesn't need the external DBI module.

- Jason

Well, I don't know about speed. I haven't programmed in perl before, but
string functions in php are pretty fast, and easy to use. Regex is not
my strong suit so I tend to favor those when dealing strings.

[Toby A Inkster]

Jason Carlton wrote:

Just curious, are these expressions slower than innate PHP expressions?

The preg_* functions are actually faster than the ereg_* functions. In
fact, the ereg_* functions are being moved out of the PHP core soon and
into an extension -- that may have even happened already.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 4 days, 16:26.]
[Now Playing: Crowded House - Better Be Home Soon]

Sharing Music with Apple iTunes
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/