•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 422,814 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,372 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 1183 | Replies: 1
 |
•
•
Join Date: Aug 2006
Posts: 999
Reputation: 
Rep Power: 4
Solved Threads: 1
Posting Shark
I do not know if this is the right place for this message to go, but there does not appear to be a forum specifically set up for the users of the PostgreSQL database, so this was the best match I could find.
Does anyone know what function or functions in Postgres would return the current date, and only that? I know of the 'now()' function, which returns the date and the timestamp, but that's no good for me; I need something which can separate the date and return only it. I'm currently building a program which requires a 'search by date' option, and the timestamp attached to the now command throws it off; no records appear in the returned set.
Anyone have any suggestions?
Does anyone know what function or functions in Postgres would return the current date, and only that? I know of the 'now()' function, which returns the date and the timestamp, but that's no good for me; I need something which can separate the date and return only it. I'm currently building a program which requires a 'search by date' option, and the timestamp attached to the now command throws it off; no records appear in the returned set.
Anyone have any suggestions?
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Installing Windows 98 On VMware. Floppy problem (Windows 9x / Me)
- Windows XP keeps restarting since a new video card (Windows NT / 2000 / XP / 2003)
- Redhat Linux 6.2 - ipop3d problem? (*nix Software)
- Problem with T720 (Gadgets and Gizmos)
- Connection Problems (Networking Hardware Configuration)
- .htaccess mod_rewrite problem (Linux Servers and Apache)
- Problem with Windows Update and WinXP (Web Browsers)
Other Threads in the Database Design Forum
- Previous Thread: CRM Database
- Next Thread: Building a Website
