How to count age?

Anna

How can I count the difference between two dates? ( I can't change
them into Unix format using mktime(), because in my database are also
people born before 1970). Are there any alternative functions?

Jul 17 '05 #1

Subscribe Post Reply

8050

Pedro Graca

Anna wrote:

How can I count the difference between two dates? ( I can't change
them into Unix format using mktime(), because in my database are also
people born before 1970). Are there any alternative functions?

Maybe this helps?
http://php.weblogs.com/adodb_date_time_library

Never tried it, can't tell if it does.
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

Jul 17 '05 #2

Sharif Tanvir Karim

"Anna" <an****@go2.pl> wrote in message
news:8b**************************@posting.google.c om...

How can I count the difference between two dates? ( I can't change
them into Unix format using mktime(), because in my database are also
people born before 1970). Are there any alternative functions?

Why not just get the year from the date field and then to some simple math
(substraction)...

--
Sharif Tanvir Karim
http://www.aftermathstudios.com

Jul 17 '05 #3

CountScubula

"Anna" <an****@go2.pl> wrote in message
news:8b**************************@posting.google.c om...

How can I count the difference between two dates? ( I can't change
them into Unix format using mktime(), because in my database are also
people born before 1970). Are there any alternative functions?

sure you can, here is an example:

$t = time() - 10000000000;
print date("F j, Y, g:i a",$t)."\n";

this will print something around: 1959

I also have a snippet that adjust from time servers 1900 based vs date()
1970 based.
http://www-4.gzentools.com/snippetvi...&v=nettime.php

--
Mike Bradley
http://www.gzentools.com -- free online php tools

Jul 17 '05 #4

Similar topics

How to count lines in a text file ?

by: Ling Lee | last post by:

Hi all. I'm trying to write a program that: 1) Ask me what file I want to count number of lines in, and then counts the lines and writes the answear out. 2) I made the first part like this: ...

Python

count (1) and count (*)

by: Geetha | last post by:

I searched in the Oracle documents what count (1) meant and I could not find an answer. Can some one explain what Oracle does internally when use count (1) VS count (*). Thank you very much in...

Oracle Database

C program to count occurences of substrings in strings

by: JD | last post by:

Hi guys I'm trying to write a program that counts the occurrences of HTML tags in a text file. This is what I have so far: #include <stdio.h> #include <stdlib.h> #include <string.h> ...

C / C++

Can't override CollectionBase.Count?

by: Eric Johannsen | last post by:

I have a simple object that inherits from CollectionBase and overrides the Count property: namespace MyTest { public class CollTest : System.Collections.CollectionBase { public override int...

C# / C Sharp

range count

by: Gary Wessle | last post by:

Hi I have a vector<charwhich looks like this (a d d d a d s g e d d d d d k) I need to get the biggest count of consecutive 'd'. 5 in this example I am toying with this method but not sure if...

C / C++

How to split one data field into 3 and count number of rows in each?

by: heckstein | last post by:

I am working in Access 2002 and trying to create a report from our company's learming management system. I am not a DBA and most of my SQL knowledge has been self taught through trial and error. I...

Microsoft Access / VBA

Select Count(*) problem

by: MP | last post by:

vb6,ado,mdb,win2k i pass the sql string to the .Execute method on the open connection to Table_Name(const) db table fwiw (the connection opened via class wrapper:) msConnString = "Data Source="...

Microsoft Access / VBA

using mysql count

by: Auddog | last post by:

I have the following query that works in mysql: select id, order_no, price, count(item_no), sum(price) from production WHERE item_no = '27714' group by item_no; When I setup my query in php,...

PHP

Place Count number into form Variable or FormField

by: jlt206 | last post by:

This code <?php include("counter.php")?> on the webpage produces the count number. (function code below) I want to place the current number into a variable $MemberNo or into a FormField to be sent...

PHP

Count Results for multiple choice

by: jaxkookie | last post by:

I have been trying to count each answer for each question and roll this up to one line item per question with totals for each answer. what I am getting is staggered answers. example, question 1 has 9...

Oracle Database

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++