List:General Discussion« Previous MessageNext Message »
From:Van Date:July 28 1999 2:42am
Subject:Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)
View as plain text  
"Christos J. Pontikis" wrote:
> 
> Hello, Van, thank you for your reply.
> 
> I send you the information you ask for.
> P.S.  I agree with you about...ghosts..!
> 
> #------------------------------------------------------------------------------
> Red Hat Linux release 5.2 (Apollo)
> Kernel 2.0.36 on an i586
> 
> [root@cosmos /root]# gcc --version
> 2.7.2.3
> 
> mysql  Ver 9.15 Distrib 3.21.30, for pc-linux-gnu (i586)
> 
> This is perl, version 5.004_04 built for i386-linux
> 
> #------------------------------------------------------------------------------
> sub currentdate_ts {
>  # get local time
>  @dt=localtime();
> 
>  $dt[5]+=1900;   $cyear=$dt[5];
>  $dt[4]+=1;   $cmonth =$dt[4];   if($cmonth<10) {$cmonth="0$cmonth";}
>  $cday=$dt[3];   if($cday<10) {$cday="0$cday";}
>  $chour=$dt[2];  if($chour<10) {$cday="0$chour";}
>  $cmin=$dt[1];  if($cmin<10) {$cmin="0$cmin";}
>  $csec=$dt[0];  if($csec<10) {$csec="0$csec";}
>  $current_date_ts="$cyear$cmonth$cday$chour$cmin$csec";
>  return $current_date_ts;
> }
> 
> #------------------------------------------------------------------------------
> 
> Regards
> 
> Christos
> http://www.medisign.gr
Christos,
Sorry, it took so long to get back to you.  I think I can help you out
on this.  There seems to be a problem with the datetime functionality
with your machine.  I may be wrong.  Go to
http://www.21ccs.com/~gboersm/y2kmatrix and download y2kmatrix.  Compile
it (let me know if you get errors), and, if it compiles (./compile;
make) go into the bin directory and type ./y2kmatrix.  You'll have a
file called y2kmatrix.out.  Do a gzip on this (gzip y2kmatrix.out), and
mail that to me at gboersm@stripped), and, I'll compare it to a known
good matrix I have, tomorrow.  This, at least will rule out problems
with your machines' ability to compile and run date-sensitive
applications.
From there we can look at your Perl scripts.  
Regards,
Van
-- 
=========================================================================
Linux rocks!!!   http://www.dedserius.com
=========================================================================
Thread
Do you believe in ghosts ???Christos J. Pontikis27 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van27 Jul
  • Re: Do you believe in ghosts ???Sasha Pachev27 Jul
Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Christos J. Pontikis27 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van28 Jul
Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Christos J. Pontikis28 Jul
  • Re: MySQL NULL value in DBI (was: Do you believe in ghosts ???)Van28 Jul