Thread timestamp (19 answers)
Opened by jan10001 at 2003-08-26 21:48

Ronnie
 2003-08-27 12:24
#32084 #32084
User since
2003-08-14
2022 Artikel
BenutzerIn
[default_avatar]
Falls du das ganze mal rückwärts brauchst (Eingabe in die DB):

Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
#!/usr/bin/perl -w

use strict;

my $date = "17/08/2003 17:19";
$date =~ s/\s+/ /go;

unless ($date eq 'NOW()') { $date = 'NOW()' if (substr($date,0,2) > 31); }
unless ($date eq 'NOW()') { $date = 'NOW()' if (substr($date,3,2) > 12); }
unless ($date eq 'NOW()') { $date = 'NOW()' if (substr($date,6,4) < 2003); }

unless ($date eq 'NOW()') {
if ($date =~ m/^(\d{2})\D(\d{2})\D(\d{4})\s+(\d{2})\D(\d{2})$/) {
$date =~ s/^(\d{2})\D(\d{2})\D(\d{4})\s+(\d{2})\D(\d{2})$/$3$2$1$4$5/o;
$date = $date.'00';
}
else { $date = 'NOW()'; }
}

print $date."\n";


Das alles um zu gewährleisten das man 'ne sinnvolle Eingabe in die Datenbank bekommt.

Gruss,
Ronnie

View full thread timestamp