Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 18-03-2009
Member
 
Join Date: Jan 2009
Posts: 74
How to convert date format in postgres

Hello friends,

I am using postgres in php.I am trying to convert date entered by user as MM-DD-YYYY format to YYYY-MM-DD format.Can anyone give me a solution for this.

Thanks in Advance.
Reply With Quote
  #2  
Old 18-03-2009
Member
 
Join Date: Dec 2008
Posts: 79
Re: How to convert date format in postgres

Sure i will help you out with this did you try to use todate method.

Intel Core 2 Duo 2.8 Ghz
G31 Asrock Motherboard with Intel chipset
2gb RAM
256 Nvidia Graphic Card
200gb HDD
Reply With Quote
  #3  
Old 18-03-2009
Member
 
Join Date: Jan 2009
Posts: 74
Re: How to convert date format in postgres

Yes i try to use todate method but i am not getting the correct answer for it.
Reply With Quote
  #4  
Old 18-03-2009
Member
 
Join Date: Dec 2008
Posts: 165
Re: How to convert date format in postgres

Try to use the following code i am sure it will work for you

string date ( string $format [, int $timestamp ] )

int strtotime ( string $time [, int $now ] )
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert date format in postgres"
Thread Thread Starter Forum Replies Last Post
How to convert math text PDF format to Kindle readable format The#Gaelic Portable Devices 7 23-02-2012 12:09 PM
How to convert avi format file to iPhone format ? hRYHORIY Portable Devices 5 13-06-2011 10:38 AM
Tips to convert MP4 format to XviD format Itronix Tips & Tweaks 2 04-02-2010 02:12 AM
Unable to convert djvu format files in JPEG format Suzane Windows Software 2 11-05-2009 05:14 PM
How do I convert from Real Player format to Windows Media Format akhtar Windows XP Support 3 06-10-2006 03:32 AM


All times are GMT +5.5. The time now is 02:31 AM.