Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 17th November 2017, 05:28
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 215
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
convert timestamp data type into date in BaaN SQL
Baan: Other/Unknown
C/S: None/Unknown

Hi,

Is there any predefined BaaN SQL oriented built function is available for converting the timestamp(UTC) data type into date data type?

Can anybody please let me know if there is a option is available?
Thanks in advance,
Regards,
Pralash
Reply With Quote
Sponsored Links
  #2  
Old 17th November 2017, 06:48
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,354
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

If you want to convert UTC Date to Date - try this -

Code:
domain tfgld.date o.date
domain tcdate i.date
long yy,mm,dd,hh,mn,ss

i.date = utc.num()

utc.to.date(i.date,yy,mm, dd,hh,mm, ss)
o.date = date.to.num  (yy, mm, dd)

If you want to convert UTC Date to String Date - refer to sprintf$()

Code:
domain tcdate i.date
string o.date(80)
i.date = utc.num()
o.date = sprintf$("%u(%02d/%02m/%04Y)", o.date) |# Convert date to string in format dd/mm/yyyy  
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 17th November 2017, 10:07
pralash pralash is offline
Senior Member
 
Join Date: Feb 2017
Posts: 215
pralash is on a distinguished road
Baan: 9.0 - DB: SQL Server - OS: Windows 2012R2
Hello bhushanchanda,
Thanks so much for your reply.... Your posting are very useful for me to grow in LN learning....
Regards,
Pralash
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Application Support Analyst - India, Chennai Jothilingam Jobs and Resumes 1 27th March 2010 15:18
Baan Parameter Tables not restored from SQL Data Backup after system crash vktonk Tools Administration & Installation 5 14th September 2009 17:09
Baan null date field view from oracle sql zaidlaz Tools Development 9 21st June 2006 17:13
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 19:39.


©2001-2018 - Baanboard.com - Baanforums.com