|
Unix Date Convertor Function |
|
| | 
| Submitted on: 10/23/2002 3:37:48 PM
By: George Graff
Level: Advanced
User Rating: Unrated
Compatibility:SQL Server 2000
Users have accessed this code 2644 times.
| (About the author) |
| | | Convert A Unix Date to a SQL date format. Can use it in your stored procs & queries
Syntax: f_ConvertUNIXDate(Unix Date column)
| |
| |
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
|
--**************************************
--
-- for :Unix Date Convertor Function
--**************************************
--
No |
code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
--**************************************
--
-- Name: Unix Date Convertor Function
-- Description:Convert A Unix Date to a
-- SQL date format. Can use it in your stor
-- ed procs & queries
Syntax: f_ConvertUNIXDate(Unix Date column)
-- By: George Graff
--
-- Inputs:(@Date Money)
--
-- Returns:A date in a normal mm/dd/yyyy
-- format.
--
-- Assumes:Couldnt use UNIX dates for my
-- apps without massaging the data on the
-- client. Now the server does it. A lot ea
-- sier, can read columns. Was looking for
-- a function like this, now it exists
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=574&lngWId;=5--for details.--**************************************
--
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SETUSER N'AHD'
GO
CREATE FUNCTION [f_ConvertUnixDate] (@Date Money)
RETURNS datetime AS
BEGIN
RETURN(DATEADD("s",@Date,'1/1/1970'))
END
| |
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
10/24/2002 2:44:03 AM:
A max value of this function can be up
to:
"select
DATEADD("s",2147483647,'1/1/1970')",
th
at is (in the format
yyyy-mm-dd):
2038-01-19 03:14:07.000
|
10/25/2002 10:31:52 AM:George Graff
Well, am using current dates in a
project. In 2038, I will be 79 yrs old,
probably will not be working, and
microsoft and oracle will probably have
merged :) who knows, right?
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
