Can not get CAST to work with DATE.

		Wrox Programmer Forums > PHP/MySQL > BOOK: Beginning MySQL
Can not get CAST to work with DATE.

BOOK: Beginning MySQL

This is the forum to discuss the Wrox book Beginning MySQL by Robert Sheldon, Geoff Moes; ISBN: 9780764579509

Read more about Beginning MySQL or buy the book from your favorite retailer
Download the code for Beginning MySQL
Buy chapters from this book in PDF

Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 13th, 2006, 09:23 AM

tuleybw

Registered User

Join Date: Feb 2005

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Can not get CAST to work with DATE.

I am trying to complete the "Try It Out" in Chp 9 (Converting Data to Different Types)
but I can not get the "CAST(DateOut AS UNSIGNED INTEGER) AS DateOut_INT" to convert the date to an integer. All I get is the 2006 year in the the DateOut_INT column. Has anyone else had this problem?

Brian

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
invalisd cast	msinha199	ASP.NET 2.0 Professional	3	May 28th, 2008 07:08 AM
"Specified cast is not valid" help	BaBaBooey	ASP.NET 1.0 and 1.1 Basics	2	November 23rd, 2004 12:12 PM
Specified cast is not valid	TheMole	BOOK: ASP.NET Website Programming Problem-Design-Solution	9	November 1st, 2004 05:09 PM
cast problem	vickyj	General .NET	6	September 8th, 2004 06:21 AM