Jump to content
Changes to the Jaspersoft community edition download ×

how to format the timestamp value


Recommended Posts

By: MohanProint - mohanproint

how to format the timestamp value

2005-03-02 22:45

I have timestamp column in my table. How do i format the timestamp in to readable format in <queryString>.Now i have "DATE_FORMAT(DATE,'%W %M %D %Y') as DATE" to get te date format. I need the readable format mm/dd/yy and time as HH:MM:SS.

 

 

By: ToRaX - torax

RE: how to format the timestamp value

2005-03-03 00:02

Google is your friend... ;-)

http://dev.mysql.com/doc/mysql/de/date-and-time-functions.html

 

 

By: MohanProint - mohanproint

RE: how to format the timestamp value

2005-03-03 01:23

U can for like this format in your <queryString> select NAME,DATE_FORMAT(UPDATE_TIMESTAMP,'%M %D %Y ') as UPDATE_TIMESTAMP from EMPLOYEE </qureyString>

it will give the output in this format March 3rd 2005

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...