Convert getdate() to int

sql casting int getdate
Danilo Lima picture Danilo Lima · Nov 26, 2012 · Viewed 16.1k times · Source

When I run the following query:

select convert(int, getdate())

I get the result:

-----------
41238

(1 row(s) affected)

Does anyone knows what does this mean?

Answer

JonH picture JonH · Nov 26, 2012

Its the number of days since I think 1/1/1900, sql-server keeps the number of days since then.

Try dividing that number by roughly 365. You should get the value back in years (112). Since 1900 + 112 = 2012

Related questions

SQL error "ORA-01722: invalid number"

A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO CUSTOMER VALUES (1,'MALADY','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES (2,'GIBSON','Jake','27 Smith St Caulfield','0415 713 598…

Read More
Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so I can insert it into another table that expects a DATE value. For example, if I have 2011/05/26 09:00:00, …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More