mysql中取出来的时间值怎么转换为现在时间【已解决】

shuaiw

我在mysql中取出来的值时一串数字，这串数字是以1970年一月一日，零点零分零秒开始算到当前时刻的时间的偏移，请问下有没有人能够帮忙解决下这个偏移怎么算。我知道有一个函数是可以解决这个问题，但是不会使用这个函数。函数为localtime，是vc系统带的函数，我决定是可以使用的，求高手帮忙

cfs43210

_DateDiff('d', $now, _NowCalc())

shuaiw

不好意思，我表达错了，我是想要一个函数能把这个偏移量换位当前时间的，就是数据库给我的是一个时间的偏移量，我怎么把这个偏移量换算成为生成这条记录的当前时间。

shuaiw

为什么我自己换算发现数据库中存的时间换算成普通时间之后会相差32小时啊

shuaiw

换算代码已经写好了，和大家分享下
#Include <Date.au3>
$time=$time1+115200
$time_year0=Floor($time/31536000);$time_year为到现在为止的过的年
$time_year=$time_year0+1970
$a=0
For $i=0 To  $time_year0-1 Step +1
If _DateIsLeapYear($i+1970) Then
        $a=$a+1
EndIf
Next
$lun=_DateDaysInMonth($time_year,2)
$time_year1=$time-($time_year0*31536000)-($a*86400)
$time_day1=Floor ($time_year1/86400)
Select
Case $time_day1<=31
                $time_mon=1
        $time_day= $time_day1
Case $time_day1-31<=$lun
        $time_mon=2
        $time_day= $time_day1-31
Case $time_day1-31-$lun<=31
        $time_mon=3
        $time_day=$time_day1-31-$lun
Case $time_day1-31-$lun-31<=30
        $time_mon=4
        $time_day=$time_day1-31-$lun-31
Case $time_day1-31-$lun-31-30<=31       
        $time_mon=5
        $time_day=$time_day1-31-$lun-31-30
Case $time_day1-31-$lun-31-30-31<=30       
        $time_mon=6
        $time_day=$time_day1-31-$lun-31-30-31
Case $time_day1-31-$lun-31-30-31-30<=31       
        $time_mon=7
        $time_day=$time_day1-31-$lun-31-30-31-30
Case $time_day1-31-$lun-31-30-31-30-31<=31       
        $time_mon=8
        $time_day=$time_day1-31-$lun-31-30-31-30-31
Case $time_day1-31-$lun-31-30-31-30-31-31<=30       
        $time_mon=9
        $time_day=$time_day1-31-$lun-31-30-31-30-31-31
Case $time_day1-31-$lun-31-30-31-30-31-31-30<=31       
        $time_mon=10
        $time_day=$time_day1-31-$lun-31-30-31-30-31-31-30
Case $time_day1-31-$lun-31-30-31-30-31-31-30-31<=30
        $time_mon=11
        $time_day=$time_day1-31-$lun-31-30-31-30-31-31-30-31
Case $time_day1-31-$lun-31-30-31-30-31-31-30-31-30<=31       
        $time_mon=12
        $time_day=$time_day1-31-$lun-31-30-31-30-31-31-30-31-30
EndSelect       
$time_hour=Floor(($time_year1-$time_day1*86400)/3600)
$time_min1=($time_year1-$time_day1*86400)-$time_hour*3600
$time_min=Floor ($time_min1/60)
$time_s=$time_min1-$time_min*60
MsgBox(4096,"",$time_year&"-"&$time_mon&"-"&$time_day&"-"&$time_hour&"-"&$time_min&"-"&$time_s)