#5830: Oracle - Timestamp field datatype issue
---------------------------+------------------------------------------------
Reporter: jaydipdave | Owner: phishy
Type: Bug | Status: new
Priority: High | Milestone: 1.2.x.x
Component: Oracle | Version: RC2
Severity: Major | Resolution:
Keywords: | Php_version: n/a
Cake_version: |
---------------------------+------------------------------------------------
Comment (by jaydipdave):
when i fetch a timestamp field, the output should be formatted like 'YYYY-
MM-DD HH24:MI:SS'.
{{{
SELECT Clientuser.lastlogin FROM clientuser;
}}}
above statement fetches it in default format (something like: DD-MMM-YYYY
HH:MI:SS0000 AM/PM).
ok, we are using "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD
HH24:MI:SS'" query to change the default format of DATE type field.
but what about TIMESTAMP field?
shouldn't we use: "ALTER SESSION SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD
HH24:MI:SS'" query?
what do you think Nate?
--
Ticket URL: <https://trac.cakephp.org/ticket/5830#comment:4>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
