Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > mysql > answers

abt date

Newbie
  
Join Date: Jul 2007
Posts: 1
#1: Jul 26 '07
how to split date in sql.???
and use the split function

dafodil's Avatar
Needs Regular Fix
  
Join Date: Jul 2007
Location: Philippines
Posts: 393
#2: Jul 26 '07

re: abt date

Quote:

Originally Posted by kracker1407

how to split date in sql.???
and use the split function

Its easier to split the date using a development language.

You can easily retrieve the date (if the date is stored in the database) and store it in a variable then you can use the string functions of that development language to split it.
mwasif's Avatar
Moderator
  
Join Date: Jul 2006
Location: Pakistan
Posts: 719
#3: Jul 26 '07

re: abt date

You can use DATE_FORMAT() to get the required part of the date.
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved