Excel Date Time to Unix Time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "jnorton" <jnorton@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 24 May 2005 09:48:06 -0700

I have a field in Excel which is formatted as 4/21/2005 10:43
I am uploading this feild into mysql I need the datetime to be converted to
unix time
like 1116910800 any ideas?

.

Follow-Ups:
- RE: Excel Date Time to Unix Time
  - From: jnorton
- Re: Excel Date Time to Unix Time
  - From: JE McGimpsey

Prev by Date: Re: Excel Won't Recognize Numbers - Can't delete space before data
Next by Date: Re: Excel file automatically entering string in cell for each row
Previous by thread: Excel file automatically entering string in cell for each row
Next by thread: Re: Excel Date Time to Unix Time
Index(es):
- Date
- Thread

Relevant Pages

Excel Date Time to Unix Time
... I am uploading this feild into mysql I need the datetime to be converted to ...
(microsoft.public.excel.misc)
Excel Date Time to Unix Time
... I am uploading this feild into mysql I need the datetime to be converted to ...
(microsoft.public.excel.programming)
Re: Excel Date Time to Unix Time
... Bob Phillips ... > I am uploading this feild into mysql I need the datetime to be converted ...
(microsoft.public.excel.misc)
Re: migration from mysql to oracle - problems with time data type
... The various tables include a mysql data types datetime, ... I can change the existing time fields to timestamp and ... mysql (or have become timestamps in Oracle). ...
(comp.databases.oracle.misc)
Re: MySqls equivalence to MsSqls TOP command/function/clause
... You want the The LIMIT clause which is used to limit the records returned by ... Have a look a the docs for mySQL ... > command/function/clause and I'm looking for some equivalence in MySql ... > A DateTime column with some swedish 100% unique formatted dateTime rows, ...
(microsoft.public.dotnet.framework.aspnet)