Hi all,

our sql server is set up to american date Time format, so as you know once
thats done you must play by its rules,

I know this is an SQL question but does anyone know how to break dates apart
using the (cast or convert functions, (I think)) IN SQL,,

its just that when I mask my date from my query I never get the right date..

I've submitted this query before, but not regarding the above...

if anyone has any ideas' I'd be well gratefull

thanx... JMC... 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to